However, expressing this as a number of months is not so straightforward, as months have different numbers of days. Finding the number of days between two dates is easy, as you simply deduct the ‘Join Date’ from the ‘Leave Date’. We knew each employee’s join date and leave date, so on paper this looked like a straightforward task. We needed to know the precise number of CALENDAR months for accounting purposes, to include both whole and part months. It works in almost the same way as the DATEDIFF() function used in the DAX language of Power BI.įor one of our master data sets, we needed to calculate how many months each of our staff had been working at our organisation. This blog looks at how to use Excel’s undocumented DATEDIF() function to calculate durations between two dates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |