Results 1 to 2 of 2

adding 15 workdays on the following month from a start date

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2019
    Location
    MIAMI, USA
    MS-Off Ver
    2010
    Posts
    1

    adding 15 workdays on the following month from a start date

    Hello,

    any assistance will be greatly appreciated.

    I need to get the 15th working day of the next following month of a start date.

    I figured it out but I have the formulas in two different cells to get my results. I used EOMONTH to get the end of the month of my start date +1 to get the first day of the next month, then i use another formula(WORKDAY) to get the 15th workday.

    I would like to combined both formulas in one cell and still get the same result. can this be possible? Thank you in advance.

    here is what i did,see attachment.
    15th working day.png

    A B

    1 START DATE 3/16/2020 formulas used YEAR HOLIDAYS
    2 4/1/2020 EOMONTH(B1,0)+1) 2019 1/1/2019
    3 15TH WORKDAY 4/22/2020 WORKDAY(B2,15,G2:G21) 1/21/2019
    2/18/2019
    HOW TO COMBINE THESE TWO FORMULAS IN ONE CELL TO GET THE SAME 5/27/2019
    RESULT OF B3? 7/4/2019
    9/2/2019
    10/14/2019
    WHAT I BASICALLY NEED IS THE 15TH WORKING DAY OF THE NEXT 11/11/2019
    FOLLOWING MONTH OF A START DATE 11/28/2019
    12/25/2019
    2020 1/1/2020
    1/20/2020
    2/17/2020
    5/25/2020
    7/3/2020
    9/7/2020
    10/12/2020
    11/11/2020
    11/26/2020
    12/25/2020
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INPUT month and OUTPUT > Weeks in the month, Start date of Wk & Start date of Wk
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-06-2018, 10:56 PM
  2. [SOLVED] Calculating Workdays for each quarter from a start and end date
    By ebe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-09-2015, 01:00 PM
  3. Workdays Including Start Date and Saturdays
    By amoto in forum Excel General
    Replies: 2
    Last Post: 05-09-2013, 02:10 PM
  4. Schedule - Start Date and End Date with Unequal Workdays
    By High_Road in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 09:48 AM
  5. count number of workdays from a start date
    By asmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2012, 01:12 PM
  6. Calendar days from start date and workdays
    By mcinnes01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2010, 10:04 AM
  7. Replies: 8
    Last Post: 03-29-2010, 09:20 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