What is the formula for adding a number of days to an existing dat
Dear all,
If in the cell A1, there is a date 05/04/2005 (i.e. May 4), if in cell B1, I want add 5 days to the date value in A1, i.e. 05/09/2005. What is the worksheet formula that I can do this calculation? Thanks. Ivan |
=A1+5
-- Regards, Peo Sjoblom "Ivan" wrote in message ... Dear all, If in the cell A1, there is a date 05/04/2005 (i.e. May 4), if in cell B1, I want add 5 days to the date value in A1, i.e. 05/09/2005. What is the worksheet formula that I can do this calculation? Thanks. Ivan |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com