Is it ever used on the weekend? Ie does Saturday and Sunday matter?
Jesse
I'm trying to formulate a cell as a date that changes only on Tuesday and Friday. The spreadsheet will be used daily, but this particular cell's date only changes on Tuesday and Friday. On Tue-Thu, the date remains Tuesday's. On Fri-Mon, the date remains Friday's.
Is it ever used on the weekend? Ie does Saturday and Sunday matter?
Jesse
This should work:
=IF(WEEKDAY(TODAY(),12)<=3,TODAY()-(WEEKDAY(TODAY(),13)),TODAY()-WEEKDAY(TODAY(),16))
Works for me today, test it again on friday, monday and tuesday.
Jesse
Yes, this spreadsheet is used everyday including Saturday and Sunday. I tested the formula and it worked today. Thanks Jessie!
Last edited by joelm; 2011-10-19 at 10:44 PM.
Bookmarks