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

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

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