Dear all, Please resolve my problem which im facing in excel
how to add
5days+10days=15days
please revert me.....
Awating for the reply
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-10Regards