View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LOU LOU is offline
external usenet poster
 
Posts: 40
Default DATE REVIEW BY COLUMN

Good Day;

I have my data as such:

ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF ColumnG
Name Date1 Date2 Date3 Date4 Date5 Date6

I need to look at the first date columnB and determine if the date if older
than 14 days if so is there a date in columnC. If columnC has a date is it 14
days old yet, if so is there a date in ColumnD and rinse and repeat. I am
trying to track my contracts as they go out for signatures to different
departments and I do not want them to sit on anyones desk to long, hence the
14day timeframe. My goal is to return a message saying complete or "review".
Any ideas or suggestions would be greatly appreciated.

Thank you,
Lou