Assuming B2 will always be earlier than C2 try this formula in D2
=EDATE(B2,CEILING(DATEDIF(B2,A2,"m")+1,12/C2))
format as date
note:EDATE requires Analysis ToolPak add-in, to install use Tools > add-ins and tick "Analysis ToolPak" box
Assuming B2 will always be earlier than C2 try this formula in D2
=EDATE(B2,CEILING(DATEDIF(B2,A2,"m")+1,12/C2))
format as date
note:EDATE requires Analysis ToolPak add-in, to install use Tools > add-ins and tick "Analysis ToolPak" box
Thank you DaddyLongLegs... worked like a charm...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks