Date difference formula between two dates. The results should be in the number of years, months (remaining from the previous full year), and days (remaining from the previous full month).
Date difference formula between two dates. The results should be in the number of years, months (remaining from the previous full year), and days (remaining from the previous full month).
Welcome to Excel Forum!
Try this formula in D3, this is for all versions of excel.
=DATEDIF([@[Latest Started IPT]],[@[Completed IPT in Jan 19]],"Y")&" Years, "&DATEDIF([@[Latest Started IPT]],[@[Completed IPT in Jan 19]],"YM")&" Months, "&DATEDIF([@[Latest Started IPT]],[@[Completed IPT in Jan 19]],"MD")&" Days"
For excel 2019 or office 365 subscriptions, you can use a shorter formula to get the same results.
=TEXTJOIN(", ",1,DATEDIF([@[Latest Started IPT]],[@[Completed IPT in Jan 19]],{"Y","Ym","md"})&{" Years"," Months"," Days"})
Hi and welcome
that will take a combination of several Datediff functions
I added some example columns and then the a column with the combined formulas to get the result you look for.
also have a look at this link for the working of used codes YM and YD and MD
https://support.office.com/en-us/art...d-8b32a451b35c
the final formula combined y, m and days looks like this
Formula:Please Login or Register to view this content.
Thanks Jason and Roel, appreciated the solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks