Thread: Track Annual Inspection Due Dates Using Conditional Formatting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tony h
 
Posts: n/a
Default Track Annual Inspection Due Dates Using Conditional Formatting

=A1+365=TODAY()

assuming a1 is the last inspection date although this might result in
the first warning date being a saturday or sunday


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=491429

Reply With QuoteReply With Quote