Forum Discussion
Solved
Calculating duration between two dates, return result in Year Month & Day count
Hello, I have a spreadsheet with hire dates listed in a column. I need to count the duration of time between the hire date and a date in another column. I want the return answer to show in year, mont...
Riny_van_Eekelen Thank you so much, this works perfectly!
What if I only have the hire date in a column and I need to calculate how many years/months/days to 12/31/2022 which is not a date on the spreadsheet, is that possible? Thank you so much for your help!
Stasha_MAPI If I understand you correctly, try and replace F3 (the end date) with DATE(2022,12,31)
- Riny_van_Eekelen
Yes, that does it. Thank you so very much!!