Calculating a future date based on a 360 day calendar

**ertavis** · 10-29-2012, 03:13 PM

I need a formula that will calculate a future date based on a 360 day calendar.

Example:
If I type in 10/19 (month & day) and need it to add 30 days to that date, it would solve for 11/19.
11/19 + 30 = 12/19
12/19 + 30 = 1/19

Hope this makes sense?!

**djapigo** · 10-29-2012, 07:19 PM

Hi ertavis,

How about this?

if 11/19 is A1, then type the following in A2

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

**ertavis** · 10-29-2012, 07:28 PM

That did it!!! Thank you SO much! This will save me a lot of work!!!

**djapigo** · 10-29-2012, 07:43 PM

Well, be careful, this formula doesn't work for every case...

The formula simply adds 1 to the month, however, end of month cases will fail...

For example: 3/31/2013 will give you 5/1/2013
Or 1/31/2013 will give you 3/3/2013

How about 2/28/2013, do you want to see 3/28/2013 or 3/30/2013?

For these cases, what do you want to see instead?