I would greatly appreciate it if someone out there in cyberspace could send a reply that teaches me how to
retrieve cell b1 or c1 data instead of a1 from sheet x for sheet y as soon as is convenient to do so.
summarized situation: An Excel 2007 workbook that tracks a teams's project status...
The workbook contains two
2.) Worksheet "X" consists of cells A2, B2, C2.
The title for A2 (located in A1)
is "Planned step date",
The title for B2 (located in B1) is "Revised step date",
The title for C2 (located in C1) is "Completed step date".
These three cells all contain formatted
2.) Worksheet "Y" consists of a single cell... A1.
The purpose of cell
A1 of worksheet Y is to simply display the current status of a specific project step's date....
So here we
go....This is what I can't figure out and am asking help solving...I have tried many different conditional statements,
formulas and looked all over online, to no avail...
I need the date listed in worksheet Y, to only display
worksheet X's A2 if B2 and C2 are blank....BUT...
If worksheet X's A2 has a date and B2 ALSO has a date (even if
the B2 date is earlier than A2's date) then I need worksheet Y's cell A1 to only display worksheet X's cell B2 date.
If worksheet X's A2 has a date, B2 has a date, AND C2 has a date (again, for all cell's older/newer dates
do not matter) then I need worksheet Y's cell A1 to only display worksheet Y's cell C2 date.
I would greatly
appreciate any help solving this...