View Single Post
  #1   Report Post  
mike099
 
Posts: n/a
Default Having a due date flag in a different colour 30 days from current.

I have a maintenance schedule for a fleet of 100 trucks. Not all come due at
the same time. I have a spreadsheet set up now that calculates when the PM's
and Annual Inspections are due but I would like something that stands out
when I look at the list to say yes, this unit is due this month, without
having to go through the whole list and manually pick out the ones due for
Jan. Then next month, have all due in Feb. be highlighted or maybe 5 days
before the new month begins.