how to add 5days+10days=15days

Tags:

Microsoft Office excel 2007 home & stude...

velraj July 22, 2010 at 09:33:32
Specs: Windows XP

Dear all,
Please resolve my problem which im facing in excel
how to add
5days+10days=15days
please revert me.....
Awating for the reply

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

Report •

Humar 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
Regards

Report •

Start a discussion

Related Solutions

› [Solved] How to add working days to a date in excel
› How to add the sum of a cell with letter and numbers
› How to add new blank row and insert data in each cell VBA
› [Solved] How to add incrementing number to a row based on a value
› Excel -how to add rows depending on criteria in original row
› [Solved] How to add workday when start date is weekend?
› [Solved] How to add days of the week automatically (POST 1)

See More ↓

Ask Your Question

Weekly Poll

Do you think another person will land on the Moon by 2024?

Poll Finishes In 7 Days.
Discuss in The Lounge
Poll History