Try subtracting 7 from that formula...FOund this online which works for the previous Sunday, but unsure how to update it for the Sunday 2 weeks ago?
Try subtracting 7 from that formula...
Although I would not use that formula, rather, just subtract 7 from whatever cell you put the formula you found in. So, if you put it in cell, say, C2, then the Sunday 2 weeks ago would be...
For previous Sunday: =TODAY()-WEEKDAY(TODAY(),2)
For Sunday before that: =TODAY()-7-WEEKDAY(TODAY(),2)
I was going to post that formula, but decided against it because you said the first formula worked the way you want. Why did I decide that? I did not want to get into the fact that he above formula returns a different value if "TODAY()" is Sunday. Now, if you will never look at your worksheet on a Sunday, then either formula is fine to use, but if you could look at it on a Sunday, you have to decide if the first formula worked for you or not.... if so, then you cannot replace it with the second formula without modifying it slightly.This works great, too. I like the logic of this formula better than the other so I will be using this one. Thanks!
@Rick Rothstein:...I did not want to get into the fact that the above formula returns a different value if "TODAY()" is Sunday.
I know... and as I said, I was going to post it as well, but the OP said the formula he posted did what he wanted, so I decided not to post it because of the different treatment for Sundays.@Rick Rothstein:
I constructed it this way intentionally: if today is a Sunday, then the previous Sunday was, well, the previous Sunday, not today.