I have one cell (say A1) that is filled with a date...say January 9, 2006. I need a formula to add 30 days to that date and then populate a cell (say C3) with the correct result (in this case the value would need to be Febuary 9, 2006).

I have tried the SUM and COUNT formulas but can't seem to arrive at the proper date...I usually get January 0, 1900, or an error.

Would appreciate the help very much.Thanks!

www.monkonline.tk

Try =A1+30

Providing the date is formatted as date and not a string all you need do is simply add 30. Dates are stored in Excel and nearly all Windows applications as a floating point number. The part before the decimal point is the number of days since 31 December 1889, hence 0 January 1900 which equals zero. The 1 January 1900 is day one in the Windows calendar.

The part ofter the decimal point is the number of seconds since midnight.

So the formula would simply be: =+A1+30

BTW: January 9, 2006 plus 30 days is February 8, 2006

Stuart

That worked perfectly. Thanks for the answer and the explanation! www.monkonline.tk

Ask Your Question

Weekly Poll

How concerned are you about the OpenSSL "Heartbleed" bug?

Discuss in The Lounge

Poll History