I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!


Monthly Fractions

If you need the number of full months or the total count of days between two days you can use DATEDIF. Easy so far. But what if you need the number of months in fractions?

This way it is done correctly:


Note: If you use the EOMONTH function you can abbreviate the formula to

Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download