• 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.



    Read about some of our Excel Development Projects

    A leading Auctioneer came to xlteq to help streamline and automate their global headcount reporting in Excel. This included real-time clarification of total headcount coupled with detailed location status functionality.

    Find our more 

    A Danish financial services company asked our Excel Consultants for support with preparing their client investment portfolios. This task now takes less than a minute per customer and is delivered in a format selected by the client then presented as a visually effective Investment Portfolio Dashboard.

    Find out more