• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 49
  • 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 HensonIT & Database AssistantCommented:
Alternative:

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

Thanks
Rob
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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