K
KeriM
I'm trying to set up a spreadsheet that has a contiguous set of date
that decrease by 7 days each row. I want it to stop at January 1st o
every year (ideally, I'd like to not hardcode the year, but I did i
that way as a test run). I tried this formula:
=IF(OR($A35=DATE(2012,1,1),""),"",$A35-7)
But I'm getting a #VALUE error. My dates are formatted as a date i
M/D/YYYY format. It works fine without the "OR" statement (so it's no
flagging empty cells). If the cell is blank without the OR, then I ge
#VALUE error (that one I understand). It seems that adding the blan
cell conditional is messing things up. Any help is appreciated
that decrease by 7 days each row. I want it to stop at January 1st o
every year (ideally, I'd like to not hardcode the year, but I did i
that way as a test run). I tried this formula:
=IF(OR($A35=DATE(2012,1,1),""),"",$A35-7)
But I'm getting a #VALUE error. My dates are formatted as a date i
M/D/YYYY format. It works fine without the "OR" statement (so it's no
flagging empty cells). If the cell is blank without the OR, then I ge
#VALUE error (that one I understand). It seems that adding the blan
cell conditional is messing things up. Any help is appreciated