View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 1
Default Has anybody figured this out yet?

Given that 'Date of service' is in column 'A' and 'Date of mailing' is
in column 'E'.

Add the formula =TODAY()-365 to cell G2

add the formula =AND($A2<$G2,$E2<$G$2) to cell F2

Drag the formula in F2 down as far as required.

'TRUE' will be displayed when a reminder is needed - e.g when BOTH the
service and mailing dates are a year old.

Hope this helps

Kev