• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

Excel 2003 Conditional Formatting for Jan 1

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?
0
thandel
Asked:
thandel
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try something like this

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

Open in new window

Regards
0
 
thandelAuthor Commented:
Thanks worked and now I learned something as well.
0
 
Rob HensonFinance AnalystCommented:
Alternative:

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

Thanks
Rob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now