Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining an annual review date from an employee start date | Excel Worksheet Functions | |||
Calculate review date | Excel Discussion (Misc queries) | |||
Months of review | Excel Worksheet Functions | |||
i have a fax sent to me for review but i cant open its saying i n | New Users to Excel | |||
excel review bar | Excel Discussion (Misc queries) |