Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Report Date - Date Recv = Days Late, but how to rid completed date
Second try at posting since the other seems to have been eaten up :-P
Sheet1! F2 = "Date Received" G2 = "Date Completed" Sheet2! C1 = "Report Date" (a variable date) A3 = "Date Received" linked from Sheet1!F2 M2 = "Days Late" (currently =DATEDIF(A3,$C$1,"d")) However, this method gives me *all* the Sheet1! files and the number of days since they've been received. What I need the Sheet2! to do is to produce a report of files that have been received but are still open (i.e. don't have "Date Completed" populated) and have the number of days of each uncompleted file appear in Sheet2!M2. And I was so pleased I at least figured out the DATEDIF formula :-) Help, please? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Report Date - Date Recv = Days Late, but how to rid completed date
You could use the Data, Filter, Advanced filter command to send all the
records that don't have anything in the date completed field. Or you could use the Data, Filter, AutoFilter to find all Blank entries in the Date Completed field and then copy them to the other sheet. You could do this with a formula but it would be more complicated. -- Cheers, Shane Devenshire "MS Questionnairess" wrote: Second try at posting since the other seems to have been eaten up :-P Sheet1! F2 = "Date Received" G2 = "Date Completed" Sheet2! C1 = "Report Date" (a variable date) A3 = "Date Received" linked from Sheet1!F2 M2 = "Days Late" (currently =DATEDIF(A3,$C$1,"d")) However, this method gives me *all* the Sheet1! files and the number of days since they've been received. What I need the Sheet2! to do is to produce a report of files that have been received but are still open (i.e. don't have "Date Completed" populated) and have the number of days of each uncompleted file appear in Sheet2!M2. And I was so pleased I at least figured out the DATEDIF formula :-) Help, please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |