How to create a date range in my Excel cells - Data Validation

How to create a date range in my Excel cells – Data Validation

por

Currently, we have not found several programs designed to help us deal with various things every day.There are people who create the documentation, others create the slides for the presentation, and some help us with it Computing and accounting management. The latter is Excel, through which several things can be done, since its spreadsheets allow us to have a variety of options.

However, it’s important to note that in order to enjoy each of these features, it’s important to download Microsoft Excel from its main platform or through the Microsoft Office suite.Now, one of the Excel tools is that with these you can Make a date rangeThat’s it, through this article, we will learn how to implement it.

date in excel cell

What types of date ranges can be done in Excel cells?

When implementing date ranges in the Excel platform, it should be mentioned that with these it is possible to combine text from multiple cells. also, exists in these different ranges, Among them we can mention:

  1. Between: This is the first and determines the dates entered in a specific range separated by a start date and an end date.
  2. It’s not between: With this, all those dates that are not in the set range will be validated.
  3. Identical: With this option, you can allow the exact same dates as allowed.
  4. Not the same: Exactly the same as the previous one, except that the value that will dominate is a date that is not within the scheduled date.
  5. Greater than: All dates greater than allowed are valid.
  6. Less than: Through them, every date greater than a given date will not be allowed.
  7. Greater than or equal to: The date remains within or greater than the determined range.
  8. Less than or equal to: Helps not to have dates that are not less than or equal to a given date.

base date range

In Excel, you can determine these data from certain ranges in the spreadsheet. base date range Those are distributed in a simple way, referencing only one cell of the table in the Excel worksheet.

Horizontal date range

On the other hand, the horizontally positioned date ranges are determined as those that establish the parameters of year, month and day in a linear fashion. Side by side, creating a horizontal way within the cell.In general, in documents with dates, users tend to These level ranges are produced because They are more specific and broader to add to each content.

enter formula in excel

What formulas are required to create a date range in Excel cells?

To generate date ranges in the Excel platform, you can use the formula it provides to each user. It should be noted that when cells in Excel are allowed to be locked, they cannot be edited, permission must be requested or a password must be established for them.However, This formulas that can be used For date ranges, they are mentioned below:

The formula ‘TEXT (39817 + 0, ‘mm / dd / yy’) returns 01 / 04 / 09′

The formula ‘TEXT(39817 + 0, ‘mm / dd / yy’) returns 01 / 04 / 09′ We have to take into account certain characteristics when using and modifying correctly.

  1. Initially, the date range to be determined is 04/01/09 to 10/01/09
  2. Also, using the formula, we will find that it is TEXT(DATE(2009, 1, 4)+ (COLUMNS ($ A: A)-1) *7,’mm/dd /yy’)
  3. The fixed dates are (2009, day 01 and month 04), which is the start.
  4. The date will return to 39817.
  5. In COLUMN (AA) – 1, a number will be created for the column.
  6. COLUMN ($A:A) will return 1.
  7. COLUMN ($A:A) – 1 will return 0.
  8. The reference in COLUMNS changes when the formula is pasted, it changes when copying and pasting.
  9. They will be converted to TEXT(39817 + 0, ‘mm/dd/yy’).

Use the formula ‘TEXT(DATE(2009, 1, 4) + (COLUMNS($A:A)-1)*7+6, ‘mm/dd/yy’)’

The formula is determined as the second part of the equation to determine the date range in the cell, Specified as follows:TEXT (DATE(2009, 1, 4) + (COLUMNS ($Y:Y) -1) *7+6, ‘mm/dd /yy’). The only difference between this and the first formula is the change in the number, which in this case is +6.

create date range in excel

How to create a date range in Excel?

the way they can Generate date ranges programmatically In Excel, it’s as simple as counting cells with a common word in Excel. The steps to consider are as follows:

  1. It should be in any cell, write the date.
  2. Subsequently, the cell must be selected.
  3. Clicking «CTRL + 1» will open a dialog where the cell formatting options are located.
  4. Click on the «General» option
  5. Press OK, the format will be selected, and the date will be displayed.

Deja un comentario