| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Another quickie...
Is there a formula I can use to add 14 days onto an entered date. For example
if the date entered was July 9th 2005 or 9-07-2005 (written the australian way) to make the cell below appear as July 23rd 2005 or 23-07-2005. The numerical option is what i have been using.... -- Heather |
|
#2
|
|||
|
|||
|
Easy: =a1+7
The 7 is the number of days. Don't forget to format the cell as a date. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Heatherbelle89" wrote in message ... Is there a formula I can use to add 14 days onto an entered date. For example if the date entered was July 9th 2005 or 9-07-2005 (written the australian way) to make the cell below appear as July 23rd 2005 or 23-07-2005. The numerical option is what i have been using.... -- Heather |
|
#3
|
|||
|
|||
|
Perfect - Thanks Anne :)
-- Heather "Anne Troy" wrote: Easy: =a1+7 The 7 is the number of days. Don't forget to format the cell as a date. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Heatherbelle89" wrote in message ... Is there a formula I can use to add 14 days onto an entered date. For example if the date entered was July 9th 2005 or 9-07-2005 (written the australian way) to make the cell below appear as July 23rd 2005 or 23-07-2005. The numerical option is what i have been using.... -- Heather |
Linear Mode
