A
arcadia
Hello,
I am new to excel and I need to work out a program for tracking dates.
I am looking at three dates to track. One is a first date for when a
review was done. I then need to track from this date, with say a later
date 2 months before the review is due, then when 1 month is due. I
would like that the cells were green for the first 10 months, then
turn yellow for a month, and then go red for the final month to warn
me it is due. As I say I am very new, if there is a complicated
formular I will need to know exactly what to do with it. TIA
I am new to excel and I need to work out a program for tracking dates.
I am looking at three dates to track. One is a first date for when a
review was done. I then need to track from this date, with say a later
date 2 months before the review is due, then when 1 month is due. I
would like that the cells were green for the first 10 months, then
turn yellow for a month, and then go red for the final month to warn
me it is due. As I say I am very new, if there is a complicated
formular I will need to know exactly what to do with it. TIA