Is there a way to set an alarm in a cell using the If formula example? (Check
me) when a Tentative date needs to be completed by
Exp: if the tentative date is getting near the completion date I would like
the completion date cell to read (Check Me) can it be based of an empty cell
Date Received Completed Date Completed By Tentative date
10/31/2007 11/14/2007
Say for example (cellA1=€�€�, Check Me) ???? then what

Please help€¦.Thanks in advance

I'm not exactly sure what you are trying to do, but if you want a cell to
read "Check Me" when the tentative date is, say, 7 days away use the
following:

=IF(B4-NOW()<=7,"Check Me","")

"ADB-NewB" wrote:

Is there a way to set an alarm in a cell using the If formula example? (Check
me) when a Tentative date needs to be completed by
Exp: if the tentative date is getting near the completion date I would like
the completion date cell to read (Check Me) can it be based of an empty cell
Date Received Completed Date Completed By Tentative date
10/31/2007 11/14/2007
Say for example (cellA1=€�€�, Check Me) ???? then what

Please help€¦.Thanks in advance

If a cell say B2 holds the Completion Date how can it also display Check Me?
How about using a Conditional Format to make the Completion Date cell go red
if its value is with in 3 days of the current date?
Let us know it this would help.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ADB-NewB" wrote in message
...
Is there a way to set an alarm in a cell using the If formula example?
(Check
me) when a Tentative date needs to be completed by
Exp: if the tentative date is getting near the completion date I would
like
the completion date cell to read (Check Me) can it be based of an empty
cell
Date Received Completed Date Completed By Tentative date
10/31/2007 11/14/2007
Say for example (cellA1="", Check Me) ???? then what

Please help..Thanks in advance

Thank you that was the formula I was lacking. Have a most wonderful day!!

"Erin Searfoss" wrote:

I'm not exactly sure what you are trying to do, but if you want a cell to
read "Check Me" when the tentative date is, say, 7 days away use the
following:

=IF(B4-NOW()<=7,"Check Me","")

"ADB-NewB" wrote:

Is there a way to set an alarm in a cell using the If formula example? (Check
me) when a Tentative date needs to be completed by
Exp: if the tentative date is getting near the completion date I would like
the completion date cell to read (Check Me) can it be based of an empty cell
Date Received Completed Date Completed By Tentative date
10/31/2007 11/14/2007
Say for example (cellA1=€�€�, Check Me) ???? then what

Please help€¦.Thanks in advance