View Single Post
 
Old 09-02-2011, 01:24 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Here is an idea to play with:

=IF(DATEDIF(I8;G8;"m")=0;"";DATEDIF(I8;G8;"m"))+IF(DATEDIF(I8;G8;"md")<15;0;1)&" months"

It will add 0 months to the initial month calculation if the days number are <15, and add 1 month if days are>=15
instead of the above formula, you can use:
=IF(DATEDIF(I8;G8;"m")=0;"";DATEDIF(I8;G8;"m"))+CE ILING(DATEDIF(I8;G8;"md")/30;0,5)&" months"
to get decimal results...and so on

Change ; with , to match your local settings
Reply With Quote