Thread: Date formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tbird333 tbird333 is offline
external usenet poster
 
Posts: 3
Default Date formula

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