+ Reply to Thread
Results 1 to 4 of 4

30 days + close to Thursday

  1. #1
    Registered User
    Join Date
    08-08-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    2

    30 days + close to Thursday

    Hello, can someone please help me with calculating 30 days from today and then get the date which is on that Thursday.
    So for example - 30 days from today will be 9/7/2021. The formula is =today()+30 which is Tuesday but I also want to add 2 more days so that every time I run the formula it adds 30 days and then a few extra days to show me the date when it will be Thursday. In short 30 days and then the closet date to Thursday.

    Thanks for your help
    Sam

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: 30 days + close to Thursday

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-08-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    2

    Re: 30 days + close to Thursday

    Can you please explain the formula. Looks like it worked.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: 30 days + close to Thursday

    It finds the first day after today +30 ignoring weekends, which are set by the "1110111" where 1 is a weekend & 0 is a workday & it runs Mon to Sun.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting after 4 days from Thursday night
    By Berna11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2020, 03:56 AM
  2. Replies: 1
    Last Post: 07-13-2014, 09:37 AM
  3. [SOLVED] Aging analysis (i.e., how many days did it take to close a case?)
    By bearligirl89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2014, 09:18 AM
  4. formula/code for if cell is thursday add 4 days if any other day add one day
    By myjebay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 12:30 PM
  5. Replies: 5
    Last Post: 01-08-2013, 11:38 AM
  6. Tracking open and closed projects - want days open or days to close
    By Aquaticape in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-07-2012, 08:18 PM
  7. average close time over the last 30 days
    By thedecarabas in forum Excel General
    Replies: 3
    Last Post: 09-21-2011, 10:57 PM

Tags for this Thread

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