DATEDIF A1B1d The formula takes two cells separated by commas and then uses a d to calculate the difference in days. For example DATE 2017142 returns the serial number representing February 2 2018. Select a cell and type the start date.
The MONTH and DAY functions only return the original values from cell A2 but the DATE function requires them.
When you press a key combination such as Ctrl. Finally the DATE function then combines these three values into a date thats 3 years in the future 020822. The DATEDIF formula takes two date cells and calculates the days between them. Perform financial forecasting reporting and operational metrics tracking analyze financial data create financial models it can be useful to insert the current time and date into an Excel spreadsheet.