View Full Version : How do I have a date change only on Tuesday and Friday?
2011-10-19, 06: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.
2011-10-19, 07:07 PM
Is it ever used on the weekend? Ie does Saturday and Sunday matter?
2011-10-19, 07:18 PM
This should work:
Works for me today, test it again on friday, monday and tuesday.
2011-10-19, 09:41 PM
Yes, this spreadsheet is used everyday including Saturday and Sunday. I tested the formula and it worked today. Thanks Jessie!
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.