You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I need assistance calculating the number of years, months, and days between two dates. When I subtract B1 and B2, it shows the result in a duration format, even after changing it to a number format. The formula works fine and provides the desired result as long as the data is in number format, as shown in my screenshot.
MacBook Pro 14″, macOS 14.6
You can use this formula
B3=DATEDIF(B1,B2,"Y")&" years, "&DATEDIF(B1,B2,"YM")&" month, "&DATEDIF(B1,B2,"MD")&" days"
It knows if a years has 365 or 366 days and also what month has 31, 30, 29 or 28 days.
Hope this will help
Regards Ralf
You can use this formula
B3=DATEDIF(B1,B2,"Y")&" years, "&DATEDIF(B1,B2,"YM")&" month, "&DATEDIF(B1,B2,"MD")&" days"
It knows if a years has 365 or 366 days and also what month has 31, 30, 29 or 28 days.
Hope this will help
Regards Ralf
Thank you so much!!
Date Subtraction: Correcting Format from Duration to Number
