Forum Discussion
Calculating length of stay of employment WITH PAST DATES
I am currently using the formula DATEDIF to caculate years/months/days of employment. I am using a workbooks for reporting purposes that is turned in quarterly. The formula currently calculates to "T...
CV2023 Cell E10 links to an external sheet for February 2023. The cell, oddly enough displays the reporting period, Month/Year, to be "February 1 - 28/29" being Month 1 through 28 or 29. without mentioning the Year.
Can't you change the source cell (E9 in the external sheet) to a real month-end date February 28, 2023. E10 will then also be a real date that you can then custom as mmmm/yyyy so that it displays February/2023. Now refer the DATEDIF function to $E$10 rather than to TODAY()
