LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining an annual review date from an employee start date Phrank Excel Worksheet Functions 3 November 29th 07 06:37 AM
Calculate review date SGT Buckeye Excel Discussion (Misc queries) 11 January 11th 07 05:18 PM
Months of review Pasty Excel Worksheet Functions 7 November 13th 06 05:17 PM
i have a fax sent to me for review but i cant open its saying i n loans New Users to Excel 3 August 25th 05 03:10 AM
excel review bar broke Excel Discussion (Misc queries) 2 May 5th 05 04:46 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"