DATE question

[Harvey Waxman]

Can you help?

I get a #VALUE! error with:

=IF(NOW()=DATEVALUE(E29),$B$27,"")

I want to enter the value of B27 if today's date is equal to the date in E29.

Thanks
-
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Remove thefrown to email me

 

[macropod]

Hi Harvey,

Apart from ensuring you've got a *string* representing a date in E29, you'll
probably get better results with:
=IF(TODAY()=DATEVALUE(E29),$B$27,"")
I suspect, however, that E29 already has a *value* represented as a date or
date & time, in which case:
=IF(TODAY()=E29,$B$27,"")
for a date, or
=IF(TODAY()=INT(E29),$B$27,"")
for a date & time, should do.

Cheers

 

[Harvey Waxman]

Assuming the date is entered in E20 as a date (not as a serial number) this
should work:

=IF(E1=TODAY(),C1,"")

It is a date. I'll try, thanks

 

[Harvey Waxman]

Hi Harvey,

Apart from ensuring you've got a *string* representing a date in E29, you'll
probably get better results with:
=IF(TODAY()=DATEVALUE(E29),$B$27,"")

I should have tried that

I suspect, however, that E29 already has a *value* represented as a date or
date & time, in which case:

=IF(TODAY()=E29,$B$27,"")
for a date, or

=IF(TODAY()=INT(E29),$B$27,"")
for a date & time, should do.

Many thanks