Date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
=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
 
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?
 
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().
 
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
 
Thanks Ed problem solved.
--
mfg41


ed said:
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
Click to expand...
 
Thanks T. problem solved.
--
mfg41


T. Valko said:
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?
Click to expand...
 
Thanks David problem solved.
--
mfg41


David Biddulph said:
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().
Click to expand...
 
Back
Top