Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Using '=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))' | Excel Worksheet Functions | |||
I need date format to be set up as month/year. | New Users to Excel | |||
Month Year Date Format | Excel Worksheet Functions | |||
create a date from year, day and month | Excel Worksheet Functions |