- date_text A date which is stored as a text and you want to convert that text into an actual date.
In the below example, I have inserted a date directly into the function by using double quotation marks.
If you skip adding these quotation marks it will return a #NAME? error in the result.
In the below example, all the dates on the left side are in textual format.
- A simple textual date which I have converted into a valid date.
- A date with all three components (Year, Month, or Day) in numbers.
- If there is no year in your textual date, it will take the current year as the year.
- And, if you have month name is in alphabets and no year.
- If you don’t have the day in your textual date it will take 1 as the day number.
Note: If you use a date which has no month in it, it will not convert that date into a date serial number.
- You can directly enter a date into the function by using double quotation mark.
- When you insert a textual date in the function it will simply give you a serial number. You can convert that serial number into a date by changing the format to date or by using the shortcut key : Control + Shift + #.