I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL TELL
ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING
I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE.
THANKS

Date differences can be computed using normal arithmetic. When you say "..
how close I'm getting..", getting close to what?

I guess you had better start searching ALL those books.....

--

Regards,
Nigel
(E-Mail Removed)



"LANCE" <(E-Mail Removed)> wrote in message
news:B4B77E9E-5EE1-40ED-BD95-(E-Mail Removed)...
>I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL
>TELL
> ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING
> I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE.
> THANKS

Please drop the all caps.

You can use Conditional Formatting to give a cell a background color when the
date entered is near a pre-set date.

=E3>$G$3-7 where G3 is pre-set date and E3 has the entered date.


Gord Dibben MS Excel MVP


On Thu, 3 Jul 2008 23:16:00 -0700, LANCE <(E-Mail Removed)>
wrote:

>I WANT TO KNOW IF THERE IS A FORMULA THAT WHEN I PUT A DATE IN. iT WILL TELL
>ME HOW CLOSE I'M GETTING. OR IT NOTIFS ME OF THE DATE. BLINKING
>I HAVE ALMOST ALL EXCEL BOOKS I THOUGHT THAT I SAW IT IN THERE SOME WHERE.
>THANKS