Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATE REVIEW BY COLUMN
I think you want 3 results - Complete, Review (withing 14 days), and Late
(not complete 14 days) Here is the formula I used. Count will give the total of the number of cells that have data in them. Six will indicate everything is filled. if everything is not filled then all you have to do is compare todays date with the date in B2. If B2 is less than 14 days from today it is in review and greater than 14 it is late. =IF(COUNT(B1:G1)=6,"Complete",IF(TODAY()-B114,"Late","Review")) "Lou" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |