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?
|