Date -Month/day/year
 

Thanks for all your help now on one of my worksheets I used this formula and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41

Date -Month/day/year
 

If you count down to the date in D7 and want to return a message when the
date is equal or less you need to switch the arrow (or switch today and D7)


=IF(D7<=TODAY(),"Time is up","")



--
Regards,

Peo Sjoblom



"mfg" wrote in message
...
Thanks for all your help now on one of my worksheets I used this formula
and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41

Date -Month/day/year
 

I don't understand your question. February 2008 is greater than today's
date, so the = condition is satisfied.
--
David Biddulph

"mfg" wrote in message
...
Thanks for all your help now on one of my worksheets I used this formula
and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41

Date -Month/day/year
 

Thanks Peo. That is what happens when you get doing to much at once. I did
not realize I had placed greater than instead of less than going to fast.
--
mfg41


"Peo Sjoblom" wrote:

If you count down to the date in D7 and want to return a message when the
date is equal or less you need to switch the arrow (or switch today and D7)


=IF(D7<=TODAY(),"Time is up","")



--
Regards,

Peo Sjoblom



"mfg" wrote in message
...
Thanks for all your help now on one of my worksheets I used this formula
and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41

Date -Month/day/year
 

I had place instead of <. That is what happens when you go to fast and are
doing to much at once.
--
mfg41


"David Biddulph" wrote:

I don't understand your question. February 2008 is greater than today's
date, so the = condition is satisfied.
--
David Biddulph

"mfg" wrote in message
...
Thanks for all your help now on one of my worksheets I used this formula
and
it works well however in D7 I ahve a date that is February 2008 and it
returns time is up.
=IF(D7=Today(),"Time is up","")

How do I make sure it reads the year as well?
Thanks again for all your help.
--
mfg41