Date Formula Help

Chris Parra

Can someone share with me the work around they are using for the following issue?

 

 

Example

 

Start Date 08/01/14

 

Time I want to add to this date - 14 months

 

Fomula I want to use

 

 =DATE(year(08/01/14),month(08/01/14) + 14, day(08/01/14))

 

Which returns an error because the month value is > 12. In excel it just adds 14 months onto the start date.

 

Am I missing something for an easy workaround?

Brett Evans

It's a doable workaround...

Year Column

IF(MONTH([Original Date]7) + Increment5 > 12, YEAR([Original Date]7) + 1, YEAR([Original Date]7))

 

Month Column

IF(MONTH([Original Date]7) + Increment7 > 12, MONTH([Original Date]7) + Increment7 - 12, MONTH([Original Date]7) + Increment7)

 

Day Column

DAY([Original Date]7)

 

New Date Column

DATE(Year7, Month7, Day7)