Date function

M

mfg41

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
 
E

ed

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
 
P

Peo Sjoblom

=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
 
T

T. Valko

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?
 
D

David Biddulph

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().
 
M

mfg

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
 
M

mfg

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...
 
M

mfg

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...
 
M

mfg

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...
 
Top