Hello All,
I was wondering if someone could help me with this an excel problem that I can't figure out.
I have an excel sheet that has a list of employees, start date, birthdate, etc. Some have start dates that go back to 1970's. I need to find a way for excel to let me know when their appraisals are due this year and next year. For example if the start date is 9/30/1978, I need excel to flag and turn the cell red 3 days before this day in 2011.
Can anyone help me with this problem? Nothing I've tried has worked.
Thank you
Hi,
You would use a formula like this as your conditional formatting rule:
=TODAY()>=DATE(2011,MONTH(A1),DAY(A1)-3)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
You could make it work on an ongoing basis - this formula used in conditional formatting will format dates red from 3 days before anniversary through to the day itself - regardless of year
=DATEDIF(A2-3,TODAY(),"yd")<=3
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks