Hi Richard,

The general (and always safest) is to use:
=Date(2005,8,5)
(thats 5th Aug 2005)

Mangesh




"Richard Buttrey" wrote in
message ...
On Fri, 5 Aug 2005 01:25:34 -0500, mangesh_yadav
wrote:


Use:

=IF(TODAY()=DATEVALUE("8/5/2005"),TRUE,FALSE)

Mangesh


Unless of course you're working with UK (& European?) style dates,
where the 5th August is generally shown as 5/8/2005.

Anyone know a general solution which would presumably use the system
locale somewhere in the formula, or is this only possible using VBA
code?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________