Formula adding 30 days to a date

July 18, 2011 at 21:42:49
Specs: Windows XP
Hi, I am looking for a formula on excel 2007 to add say 30 days to a date. I am wanting to set up a spreadsheet that when you add the current date it will calculate what the date will be when 30 days has passed or when 60 days has passed. I don't need to worry about working days just calendar days.

See More: Formula adding 30 days to a date

Report •


#1
July 19, 2011 at 05:25:27
With your date in cell A1 in cell B1 enter the formula:
=A1+30 for 30 days
=A1+60 for 60 days

etc. etc.

MIKE

http://www.skeptic.com/


Report •

#2
July 21, 2011 at 20:57:49
Thank you so much Mike! Now I need to know how to calculate what the date would be at the end of the month and the 15th of the month? Would you have any idea? Same concept as before regarding adding days and getting the end of that month instead of 30 days, if you see what I mean?

Report •

#3
July 22, 2011 at 05:01:56
Try this:

End of Month:

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

You should be able to figure out how to get the 15th.

Here is a great site for Excel info:

http://www.cpearson.com/excel/datet...

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
July 22, 2011 at 10:44:38
This will give you the end of the month for the date in A1
=eomonth(a1,0)

This will find the Next 15th of the month after the date in A1, if the date in A1 is the fifteenth then it will return the fifteenth of the following month.
=if(day(a1)<15,eomonth(A1,-1)+15,eomonth(a1,0)+15)


Report •

Ask Question