| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date function
Thanks in advance for any help I can get.
I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
It would help to post you formula althoough if the date is in A1 you could
do =IF(A1=NOW(),"It's greater","It's Less") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
On Aug 9, 3:46 pm, mfg41 wrote:
Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster put =today() in cell E5. Put the target date in F5 as (for instance) 8/10/07. Conditional format cell E5 to whatever you want if "cell value" is "Greater than" =F5 ed |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
=TODAY()=A1
where A1 holds the date you want to check, dates are just serial numbers counting from Jan 0 1900 so except for formatting there is nothing special, pure numbers -- Regards, Peo Sjoblom "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Try this:
A1 = some date (like: 8/15/2007) B1 = formula =AND(ISNUMBER(A1),TODAY()=A1) This will return either TRUE or FALSE. Is that what you had in mind? -- Biff Microsoft Excel MVP "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
It's difficult when we are having to guess what formula you've used, but did
you perhaps use TODAY without the parentheses? It should be TODAY(). -- David Biddulph "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Thanks Ed problem solved.
-- mfg41 "ed" wrote: On Aug 9, 3:46 pm, mfg41 wrote: Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster put =today() in cell E5. Put the target date in F5 as (for instance) 8/10/07. Conditional format cell E5 to whatever you want if "cell value" is "Greater than" =F5 ed |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Thanks Nick. I see you are from Southampton I am from Havent but am living in
the northwest Territories Canada. Anyway the problem solved thanks.-- mfg41 "Nick Hodge" wrote: It would help to post you formula althoough if the date is in A1 you could do =IF(A1=NOW(),"It's greater","It's Less") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Thanks T. problem solved.
-- mfg41 "T. Valko" wrote: Try this: A1 = some date (like: 8/15/2007) B1 = formula =AND(ISNUMBER(A1),TODAY()=A1) This will return either TRUE or FALSE. Is that what you had in mind? -- Biff Microsoft Excel MVP "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Thanks David problem solved.
-- mfg41 "David Biddulph" wrote: It's difficult when we are having to guess what formula you've used, but did you perhaps use TODAY without the parentheses? It should be TODAY(). -- David Biddulph "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "mfg" wrote in message ... Thanks T. problem solved. -- mfg41 "T. Valko" wrote: Try this: A1 = some date (like: 8/15/2007) B1 = formula =AND(ISNUMBER(A1),TODAY()=A1) This will return either TRUE or FALSE. Is that what you had in mind? -- Biff Microsoft Excel MVP "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date function
Great, glad it fixed it
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "mfg" wrote in message ... Thanks Nick. I see you are from Southampton I am from Havent but am living in the northwest Territories Canada. Anyway the problem solved thanks.-- mfg41 "Nick Hodge" wrote: It would help to post you formula althoough if the date is in A1 you could do =IF(A1=NOW(),"It's greater","It's Less") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "mfg41" wrote in message ... Thanks in advance for any help I can get. I am trying to place a function in a cell that will let me know if the date today is = or than the date in that cell. I keep getting #NAME coming up when I try to do this. I have entered the date formula in the required cell. M. Foster |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
