KhodrK1590
New member
- Joined
- Oct 18, 2021
- Messages
- 6
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2021
Hello,
I want to make the duration of two dates closest to years in months, what formula would I use?
for example, I have a start date/end date of
when I do DATEIF in months I get 59, however, I want it to round up to the nearest 12 month in years, so for example, I want it to be 60 months.
what would I add to my formula or how would I write it? Let's say start date is A1 and end date is B1.
Basically, I have several dates and need them all to be as close to 12 x x as possible.
I want to make the duration of two dates closest to years in months, what formula would I use?
for example, I have a start date/end date of
| 9/1/21 | 8/30/26 |
when I do DATEIF in months I get 59, however, I want it to round up to the nearest 12 month in years, so for example, I want it to be 60 months.
what would I add to my formula or how would I write it? Let's say start date is A1 and end date is B1.
Basically, I have several dates and need them all to be as close to 12 x x as possible.
