Datedif issue - convert number of days to --Years--Months--Days format

Question

I should change the structure of the days to "—Years—Months—Days." Most of my calculations involve working day percentages.

=DATEDIF(B2,C2,"y")&" years "&DATEDIF(B2,C2,"ym")&" months "&DATEDIF(B2,C2,"md")&" days"

is effective for date-to-date. I need the day counts in this case. in the format "—Years—Months—Days."

like: 10 September 2021 to 1 March 2023 (546 days) 75% of 546 is 409.5 I have to figure out how many years, months, and days there are in 409.5. Can it be done?

Answer 1

Try,

=DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") & " Months, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"MD") & " Days"