Excel 2007 - Conditional Format Using Calendar Months

Closed
Boondagger Posts 1 Registration date Thursday February 13, 2014 Status Member Last seen February 13, 2014 - Feb 13, 2014 at 02:20 PM
 Blocked Profile - Feb 13, 2014 at 02:32 PM
I'm have a workbsheet that has a bunch of dates that show when people have completed their annual training.

What I'm trying to do is take the training dates and set up some conditional formatting to make things even more simplified for the casual user. I've looked around and I can't find any thread that covers exactly what I'm doing, although I've been close a few times.

The conditional formatting for the dates in cells B2:B210 need to reflect the following info:

(All training is due annually)

1. Dates that are due in the next 2 months (calendar months, not 60 days)
2. Dates that are due next month (calendar month, not 30 days)
3. Training that is overdue as of today (dates at least one year old)

I hope that gives enough information, and thank you in advance. I've been stumped for weeks now.
Related:

1 response

Blocked Profile
Feb 13, 2014 at 02:32 PM
Hey, nice scope.

But, by calender, do you mean weekdays?

We can use NETWORKDAYS(first-date,second_date)
it will return number of weekdays between the two.

See Below:

"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
0