how to add 5days+10days=15days

Microsoft Office excel 2007 home & stude...
July 22, 2010 at 09:33:32
Specs: Windows XP
Dear all,

Please resolve my problem which im facing in excel
how to add
please revert me.....
Awating for the reply

See More: how to add 5days+10days=15days

Report •

July 22, 2010 at 09:49:26
You haven't said what you are trying to do with your 15 days.

As Excel uses a value of 1 for a day (one 24 hour period)
then =5+10 returns 15, is 15 days in Excel's date system.

If you started with a date in cell A1 say 22/July/2010
Then in B1 entered =A1+5
and in C1 entered B1+10,
you would get these dates:
B1 ... 27-Jul-10
C1 ... 06-Aug-10


Report •
Related Solutions

Ask Question