How do I have a date change only on Tuesday and Friday?

joelm

New member
Joined
Oct 19, 2011
Messages
2
Reaction score
0
Points
0
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:
Back
Top