Formula Help for Scheduling
Posted by Scott Currie on March 27, 2001 6:06 AM
I was looking for a lot of help...I am creating a schedule keeper for our office and have hit a roadblock. Any help would be greatly appreciated.
Here it goes:
Col A - Visits per year (varies could be 2, 3, 4 etc.)
Col B - Date of Scheduled Service
Col C - Date Service Actually Done
Col D - Next Service Date
I was looking to do the following...
Col B - I want to turn Italic RED within 2 wks. of actual date, and turn Italic BLUE after date in box passes.
Col C - I will type in date service is done, effectivly making date in Col B go back to Italic BLACK.
Col D - I want this to add Col A and Col C. (Eg. 3/28/01 service is done and it will be 60 days till next service so Col D will automatically go to 5/28/01) Then I want it to turn Italic RED within 2 wks. of actual date, and turn Italic BLUE after date in box passes.