Results 1 to 7 of 7

Find Every Tuesday or Thursday

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Question Find Every Tuesday or Thursday

    Hi Group,

    I'm starting to develop a project schedule which has a lot of sub-projects within it.

    I wish to start 2 projects per week & want to start 1 on Tuesday's & the other on Thursday's

    If I was to start a project on, 04/12/16 (Tuesday), then I'm looking to find every following Tuesday or Thursday until the end of the year

    Starting Date, 04/12/16
    In cell I14 - I have a "Yes" / "No" drop down which stating to start 2 projects per week or "No" for 1 project to start for week.

    With this function,
    =IF($I$14="Yes",K31+2,IF(I14<>"Yes",K31+7))

    I'm not getting every Tuesday or Thursday.

    How to modify?

    Thanks
    Last edited by mycon73; 02-02-2016 at 03:24 PM.
    MyCon
    -- Using Latest Version of Excel

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How can I find the data this coming Thursday?
    By tuph in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2015, 01:55 AM
  2. Find the last Thursday in the list
    By goodboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-27-2015, 09:46 AM
  3. Replies: 6
    Last Post: 09-03-2014, 02:06 PM
  4. [SOLVED] How do you get a cell to be Tuesday-Thursday?
    By galvanator in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2014, 07:03 PM
  5. Subtract Tuesday, 8-23-11 at 1:00PM from Thursday, 8-25-11 at 5:00 PM
    By skygazer11030 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2011, 01:56 PM
  6. Find The Tuesday (Finish The Formula!)
    By SamuelT in forum Excel General
    Replies: 2
    Last Post: 11-28-2007, 10:02 AM
  7. [SOLVED] Find the previous Weekday (thursday)
    By JimDandy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2006, 02:25 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1