Originally Posted by
reddick.ross
Made an excel calendar which serves as a "deadlines reminder" calendar.
I want to be able to fill color on the final deadline. The script would fill in other mini deadlines based on the amount of WEEK-days (i.e. work days) from the final deadline.
For example, if the final deadline is Tuesday, Feb 2, 2010, I would fill that with the color red (or some kind of marker). There are two mini deadlines that I want to autofill, one that is four days before that Tuesday, the other is 10 days. So I want the function/macro to fill Jan 27 (4 work days before) with a different color. And Jan 19 (10 days before) with yet another color.
The problem is in ignoring the weekend days.
Remember the point is to have a simple visual reminder of approaching deadlines, so I need the results on the first sheet of the file I uploaded. The second sheet is a linear list of dates in 2010; the solution will most likely use this and the workday function
Thanks in advance.
Bookmarks