LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 155
Default formula to update dates periodically

I am creating a spreadsheet and one column will have a date established and
another column will have a follow-up date, which will be three weeks from
established date. Is there a formula to change the follow-up date every three
weeks and can it stop changing when the word "closed" is entered in another
column. The follow-up date already has a conditional format to turn red and
alert user that notices are due. The esatblish date is permanent.
 
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 Periodically Store/Save Excel DDE Values ** Excel Discussion (Misc queries) 1 August 10th 07 09:17 PM
Periodically listing files in a folder haven104 Excel Discussion (Misc queries) 2 January 10th 06 09:01 AM
Periodically exporting Excel sheet to HTML SupportX New Users to Excel 1 July 4th 05 07:00 PM
No update of dates [email protected] Excel Discussion (Misc queries) 7 May 29th 05 06:36 AM
Dates that automatically update ... Artanis Excel Discussion (Misc queries) 3 March 10th 05 12:21 PM


All times are GMT +1. The time now is 02:24 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"