Date formula

  • Thread starter Thread starter tbird333
  • Start date Start date
T

tbird333

I am making a spreadsheet for upcoming training and it due dates. i am
trying to set it up where when training is complete you enter the date and
time, and then when it comes withing 3 month of being due again it changes
color, and then at one month it changes again. I am having a hard time
finding the rule/formula to make this work
 
Select all the due dates, use Format/Conditional Formatting, change Cell
Value is to Formula Is, enter
=A2+30>TODAY() (assumes A2 is the active cell -- substitute as appropriate)
then click the Format button and assign one color, click OK, click Add>>,
change Cell Value is to Formula Is, enter
=A2+90>TODAY(), click Format, assign a different color, OK your way out...
 
I need to put in the date it was complete(say yesterday) and when it is
within 3 months of being due turn yellow, and with in 30 days turn red. so i
put in a completed date and when it is at 305 or 335 days form complete it
changes color

I used the formula given below and received a relative reference message
 
Back
Top