DATE YEAR A2 INT MONTH A2-131311-1 For 26-May-2018 it returns 30-Jun-2018 which is the last date of the quarter. When you use the TODAY function Excel uses your computers current date for the date. For example the date 19-Jan-2000 is stored as 36544 since 36544 days have passed since 1900-Jan-0.
Select the Column of dates for example Column A in my image above Under the Data tab select Text to Columns its a.
This function is useful in formulas where you need to calculate an age. Filling a column or row with dates that increment by one day is very easy. DateIsInCurrentDay Indicates whether the given datetime value dateTime occurs during the current day as determined by the current date and time on the system. Count Days Add Days Workdays Add Workdays Weekday Week.