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.

With your date in cell A1 in cell B1 enter the formula:

=A1+30 for 30 days

=A1+60 for 60 daysetc. etc.

MIKE

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?

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

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)

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History