Articles

Solved Excel forumula to add 30 days

January 9, 2006 at 09:57:36
Specs: WinXP/Office2003, n/a

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


See More: Excel forumula to add 30 days

Report •


#1
January 9, 2006 at 10:37:49

Try =A1+30


Report •

#2
January 9, 2006 at 10:45:00
✔ Best Answer

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


Report •

#3
January 9, 2006 at 11:49:23

That worked perfectly. Thanks for the answer and the explanation!

www.monkonline.tk


Report •

Related Solutions


Ask Question