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