Month/Day formula

[Pizzio]

Typically I would use datedif( for my date range formulas but I I find it rounds whole months. I'm looking for a formula that would give me these results.

10/01/23 - 12/15/23

Datedif( RESULTS: 3 months
LOOKING FOR RESULTS: 2.5 months

 

[Joe4]

You can subtract one date from the other and divide by 30 to if you want approximate fractional months.
Or divide by (365/12) if you want a more exact value.

 

[Pizzio]

The formula worked with within a single year. What if I have dates spanning multiple years? Is there something similar to 'datedif(' where it counts the number of days and the output is placed in a month format?

 

[Joe4]

The formula worked with within a single year. What if I have dates spanning multiple years? Is there something similar to 'datedif(' where it counts the number of days and the output is placed in a month format?

Instead of dividing the difference in days by 30, divide by (365.25/12), which is a little over 30 and should get you very close.

The logic is that there are 365 in most years, except every fourth year it has 366 (except for once a century).
So 365.25 days is a good estimate of the number of days in any year.