Stop updating today() when another cell has d

April 16, 2011 at 05:40:18
Specs: Windows XP
I have a spreadsheet in Excel 2003 used to track service orders. Column H is the Date the Service order was opened, J reflects the number of days the service order is open, using =TODAY()-H3, for row 3, column L is the date the Service Order is closed. I want the auto update TODAY() to stop once a date is entered in column L of the same row. I'm certain a macro is needed, but i don't know anything about macros. Any help will be most appreciated.

See More: Stop updating today() when another cell has d

Report •

April 16, 2011 at 07:15:39
I'm certain a macro is needed
Not necessarily.

There is a way you can "side-step" the =Today() function,
if your data is set up correctly.

In cell H3 is the Date of Service
In cell J3 is the number of Days
In cell L3 is the Date Order Closed.

Your current formula is =TODAY()-H3

If you modify your formula like this:


As long as the Date Order Closed is blank,
then you count days using the volatile =TODAY() function.

When you enter a Closing Date,
then we stop using the =TODAY() function and use the date in cell L3
which is your Order Closed Date.

Try that.


Report •

April 16, 2011 at 20:03:45
PERFECT!! You're a genius!! Everything I have learned about Excel I have learned on blogs and Online Tutorials like this! Thanks to guys like you, I too will be a genius one day! HA! Have a Blessed day!

Report •

Related Solutions

Ask Question