Conditionally Format Particular Dates

[robzrob]

Can't seem to work this one out.

Col A has dates in it. If today is either a Friday, Saturday or
Sunday, and the date in A is more than 1 yr before the coming Sunday's
date (or today's date if today is Sunday) conditionally format (turn
red, underline, whatever) A. If today is any other day and the date
in A is more than 1 yr before today, conditionally format (turn
red...etc) A.

I hope I've explained that clearly.

(Need it to work for leap years as well as ordinary years.)

Regards

 

[Jim Cone]

Give this a try...
=OR(AND(WEEKDAY(TODAY(),2)<5,YEARFRAC(TODAY(),A1,1)>1),AND(WEEKDAY(TODAY(),2)>4,YEARFRAC(TODAY()+7-WEEKDAY(TODAY(),2),A1,1)>1))
'---
Depending on xl version, requires loading analysis tool pak

--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
editorial review of special sort excel add-in (30 ways to sort)






"robzrob" <[email protected]>
wrote in message
news:[email protected]...