Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 45 Day Count Down Timer

I am creating a worksheet to track a 45 day window. I need the worksheet to
count down in days from 45 to 1 in column L from any date entered in column K.

45 Day Count Down Timer In L4 When Date Is Entered in K4
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9,101
Default 45 Day Count Down Timer

Put in in L4

=K4-1.

Format column L any date format.

Then in L5 put the formula
=L4-1

Copy the cell L5 down the column for 45 day until cell L48.

"da_bigone" wrote:

I am creating a worksheet to track a 45 day window. I need the worksheet to
count down in days from 45 to 1 in column L from any date entered in column K.

45 Day Count Down Timer In L4 When Date Is Entered in K4

Reply
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
count down timer NED Excel Discussion (Misc queries) 3 December 11th 07 12:39 PM
count day timer NED Excel Discussion (Misc queries) 3 December 11th 07 12:38 PM
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM
Timer, Tally, and Count Jay3253 Excel Discussion (Misc queries) 0 October 25th 05 09:02 PM
Count-down timer? (e.g. 10 days left...9...8...) mesotech Excel Discussion (Misc queries) 2 January 6th 05 04:38 PM


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

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

About Us

"It's about Microsoft Excel"