• Excel Developer Tips Useful Data Formulae

  • Excel Developer Tips - 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.