LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I get a function to execute on a specific date in Excel?

I am trying to get a result of a function to display in a cell based on the
system date. Once the date is passed, I would like to display the difference
in the two previous cells. I am using Excel 2007 to track changes, and there
are three key dates when I need the function to execute. I've been trying to
use the DATE and DATEVALUE functions, but can't quite seem to get what I am
looking for. thanks.
 
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
Date Function formula that will return the date of a specific week Greg Excel Worksheet Functions 4 June 12th 06 05:07 PM
can I execute and 'substring' function in Excel Larry Excel Worksheet Functions 4 January 1st 06 08:16 PM
How do i execute a VBA function by clicking on an excel cell? Matthew Excel Discussion (Misc queries) 1 December 7th 05 01:10 AM
specific date function jenniferm Excel Worksheet Functions 2 September 20th 05 07:26 PM
how do i make a cell date sensitive to execute a formula or input. ebuzz13 Excel Discussion (Misc queries) 2 January 20th 05 08:33 PM


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