Excel 2003 Conditional Formatting for Jan 1

thandel
thandel used Ask the Experts™
on
I have cells with dates formatted as DDD,MM/DD/YY (Example Mon, 03/01/21016).  I am trying to setup a conditional format for when the date is Jan 1 for any year.  I've tried the conditional format with search without luck.

is this possible?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try something like this

=DATE(2000,MONTH(A1),DAY(A1))=DATE(2000,1,1)

Open in new window

Regards

Author

Commented:
Thanks worked and now I learned something as well.
Rob HensonFinance Analyst

Commented:
Alternative:

=AND(MONTH(A1)=1,DAY(A1)=1)

Thanks
Rob

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial