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?

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?