On The Road
[Excel] Referencing a formula in another sheet
I have a 2 week timesheet on each sheet. Just because, I made 30 of them in the workbook. F1 is the starting date for the season. L1 contains this formula and it works fine. I have to fill in F1 each 2 weeks on each sheet.
=IF(ISNUMBER(F1);( F1+13); "" )
So, the next sheet (sheet2) I would like it to look at L1 of the previous sheet and fill in F1 as L1+1.
=IF(ISNUMBER(sheet1!L1); (sheet1!L1+1);"" )
This never works. Even if I don't check to see if there is a number there. I assume it's because L1 is a formula and not a real date. L1+1 works in the same sheet, just not with the Sheet1!L1+1. Can this be fixed? What am I doing wrong?
Damn spy drones!
They are interfering
with my sun spots.
I have Excel 2003 and did this:
Sheet1 cell F1 is a date (I entered 9/1/12 for this example).
Sheet1 cell L1 I put the formula =IF(ISNUMBER(F1),F1+13,"")
Sheet2 cell F1 I put the formula =IF(ISNUMBER(Sheet1!L1),Sheet1!L1+1,"")
Sheet2 cell L1 I put the formula =IF(ISNUMBER(F1),F1+13,"")
Sheet1 cell F1 shows 9/1/2012
Sheet1 cell L1 shows 9/14/2012
Sheet2 cell F1 shows 9/15/2012
Sheet2 cell L1 shows 9/28/2012
Is that the kind of result you're after?
Note: In Excel 2003 if I try to use a semicolon in the formula instead of a comma, I get an error message about the formula having an error.
On The Road
|reply to beck |
Thank you! That was it. I don't do enough in Excel to know differences between versions. I'm using Excel 2003.
You're welcome; I'm glad I was able to help!