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

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

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

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

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

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

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

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

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

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

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

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