View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scotty scotty is offline
external usenet poster
 
Posts: 45
Default Excel 2003 make 1 date cell automatically change another date cell

I am using Excel 2003 and within a new spread sheet that I am creating I have
2 cells with dates in them. 1 cell is the date that the equipment was
inspected and the other cell is the date that the equipment needs re
inspection.
When this spread sheet is completed I would like to only change the date in
the inspection date cell and if available there be a formula to automatically
change the retest date.