PDA

View Full Version : How do I have a date change only on Tuesday and Friday?



joelm
2011-10-19, 07:27 PM
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.

Jesse
2011-10-19, 08:07 PM
Is it ever used on the weekend? Ie does Saturday and Sunday matter?

Jesse

Jesse
2011-10-19, 08:18 PM
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

joelm
2011-10-19, 10:41 PM
Yes, this spreadsheet is used everyday including Saturday and Sunday. I tested the formula and it worked today. Thanks Jessie!