Ryan.Vogel4012
New Member
- Joined
- Jun 1, 2012
- Messages
- 1
I have a large spreadsheet with lots of dates that I would like to check and report in a easy to read Spreadsheet. Would like names to be populated on the new sheet based on if they are 60 days out from being due, 30 days out, and overdue.
Have tried using
=IF(OR(B4>=Sheet1!S2,B4>=Sheet1!U2,B4>=Sheet1!V2,B4>=Sheet1!W2,B4>=Sheet1!X2,B4>=Sheet1!Y2,B4>=Sheet1!Z2), Sheet1!E2,)
This will export the name over to sheet two, but I would like it to export what is in the top row (name of item due) as well.
NAME EVENT EVENT EVENT
JOHN 7/9/2012 8/16/2012 9/9/2012
STEVE 5/15/2012 7/18/2012 9/9/2012
Any ideas? Thanks for any help
Have tried using
=IF(OR(B4>=Sheet1!S2,B4>=Sheet1!U2,B4>=Sheet1!V2,B4>=Sheet1!W2,B4>=Sheet1!X2,B4>=Sheet1!Y2,B4>=Sheet1!Z2), Sheet1!E2,)
This will export the name over to sheet two, but I would like it to export what is in the top row (name of item due) as well.
NAME EVENT EVENT EVENT
JOHN 7/9/2012 8/16/2012 9/9/2012
STEVE 5/15/2012 7/18/2012 9/9/2012
Any ideas? Thanks for any help