Useful Data Formulae
- EDATE – allows you to add months to a date but requires the cells to be formatted as dates or will return a number
- DAY/MONTH/YEAR – returns the day/month/year of a date as a number
- WEEKDAY – returns a number from 1 to 7 identifying the day of the week.
- TODAY() – today’s date
- DAYS – the number of days between two dates.