?
Solved

Excel 2003 Conditional Formatting for Jan 1

Posted on 2016-11-25
3
Medium Priority
?
43 Views
Last Modified: 2016-11-28
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
Comment
Question by:thandel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 41901782
Hi,

pls try something like this

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

Open in new window

Regards
0
 

Author Closing Comment

by:thandel
ID: 41901823
Thanks worked and now I learned something as well.
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41904478
Alternative:

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

Thanks
Rob
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question