Results 1 to 4 of 4

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Is it ever used on the weekend? Ie does Saturday and Sunday matter?

    Jesse

  3. #3
    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

  4. #4
    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 09:44 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •