Excel Developer Tips Useful Data Formulae

Useful Data Formulae

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