LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 276
Default Date "E2" to add 7 days How?

I think this is quite simple but i want to create a short code to add 7 days
to a date in cell E2.
The cell is formatted so it display a date in a 31 October 2006 view.

Please help.


Regards

Corey


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to go "X" number of days out from a undefined date? Max Excel Discussion (Misc queries) 3 February 19th 07 08:44 PM
get a runing total for"curent date"or(cell)minus prev 30 days( cel dustin Excel Worksheet Functions 2 August 1st 06 09:59 AM
can we convert "2 days 16 hrs" to " 64hrs" using excel functions chris Excel Worksheet Functions 5 April 24th 06 12:53 AM
"DAYS 360" and the date Feb 28th as start and end Petteri Tuominen Excel Worksheet Functions 4 March 2nd 06 04:30 PM
TODAY'S DATE PLUS "BUSINESS" DAYS Lisa Excel Programming 3 December 8th 04 09:20 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"