LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cstandinguk
 
Posts: n/a
Default is it possible for a cell to change a date every 7 days ??


Hi.

I am working on a spreadsheet for work. The problem is i have a
vertical list of 4 dates each one 7 days in front of the other
(consecutive weeks).

Is it possible to automate the dates so they automatically update to
show the next 7th day, every 7 days ?

Sorry if this sounds confusing. Any help is greatly appreciated as I am
something of a novice!

Many Thanks

Chris


--
cstandinguk
------------------------------------------------------------------------
cstandinguk's Profile: http://www.excelforum.com/member.php...o&userid=31685
View this thread: http://www.excelforum.com/showthread...hreadid=513826

 
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
In excel,how do I change the date to a date 84 days from previous Alister Edmond Excel Discussion (Misc queries) 3 February 9th 06 02:24 PM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 12:25 PM
cell color change based on due date MINAL ZUNKE New Users to Excel 2 June 30th 05 09:24 PM
how do i change 20050614 within in a cell to a recognised date Richard carpenter @ uniq Excel Worksheet Functions 1 June 8th 05 11:32 AM
How do I change the value in cell based on a future date John W Excel Discussion (Misc queries) 2 December 21st 04 01:27 AM


All times are GMT +1. The time now is 08:44 PM.

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"