+ Reply to Thread
Results 1 to 4 of 4

Does the date fall within X amount of working days from start of the month

  1. 01-15-2016, 06:45 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Does the date fall within X amount of working days from start of the month

    Hi,

    Has anyone got a formula which would calculate if a date falls in the first 5 WORKING days of the month e.g.

    01/01/2016 No
    02/01/2016 No
    03/01/2016 No
    04/01/2016 Yes
    05/01/2016 Yes
    06/01/2016 Yes
    07/01/2016 Yes
    08/01/2016 Yes
    09/01/2016 No
    Etc


    ?
    Reply With QuoteRegister To Reply
  2. 01-15-2016, 08:40 AM #2
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Does the date fall within X amount of working days from start of the month

    I think the following will do what you want however I dont understand your examples, surely 01/01 to 03/01 fall within the first 5 working days?
    Please Login or Register  to view this content.
    however if you also want to check that the date itself is a working day then I think you'll need to use:
    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
  3. 01-15-2016, 09:23 AM #3
    llamafarmer
    llamafarmer is offline
    Forum Contributor
    Join Date
    02-26-2014
    Location
    Aylsham, Norfolk, UK
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Does the date fall within X amount of working days from start of the month

    pj,

    The first 3 days of the week were either bank holiday or weekend:
    Friday 1st - Bank Holiday (Boxing day)
    Sat 2nd - Weekend
    Sun 3rd - Weekend
    Reply With QuoteRegister To Reply
  4. 01-15-2016, 10:12 AM #4
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: Does the date fall within X amount of working days from start of the month

    Hi,

    Thanks for replying - you are spot on. 1st was a bank holiday and other two are weekends
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Does a task start or finish date fall within 3 month range of a specific date
    By jamesmcgallan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2015, 07:46 AM
  2. How to work out the amount of days in a week that fall in a given month
    By phoner1 in forum Excel General
    Replies: 4
    Last Post: 07-30-2014, 07:02 PM
  3. How to auto populate date range (working days only) from start date and end date
    By ihwk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2014, 03:46 AM
  4. [SOLVED] Get the amount of working days in a month using the computer date
    By Drunknmonkie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-06-2013, 08:10 PM
  5. Formula to count days IF the dates fall within the period(start and end date only given)
    By angelkulit025 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-26-2013, 08:32 AM
  6. [SOLVED] Calculating contribution of sales by month with given amount, start date, and end date
    By kidnos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2013, 02:20 PM
  7. [SOLVED] amount of working days per month
    By Nigel in forum Excel General
    Replies: 2
    Last Post: 11-29-2005, 06:45 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1