Results 1 to 17 of 17

fill between two date according to working day and non working day , holidays

Threaded View

  1. 01-23-2017, 02:51 PM #1
    mazan2010
    mazan2010 is offline
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    fill between two date according to working day and non working day , holidays

    Hello
    i would like to fill in column C date between two date A2, B2 with consideration to Working day is only
    Sunday
    Monday
    Tuesday
    Wednesday
    and non working day which not need in this interval
    Saturday
    Thursday
    Friday

    and holiday In column G

    by formula or VBA code
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. fill automatic between two date and calculate working day
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-31-2016, 02:11 PM
  2. [SOLVED] CFormat for Stat Holidays not working right
    By BlindAlley in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-04-2015, 01:38 PM
  3. calculate the working days and Holidays
    By sriku in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2014, 02:03 PM
  4. Workday , Holidays - Comapring Previous Date and Days of Working
    By coolguykets1 in forum Excel General
    Replies: 3
    Last Post: 10-30-2013, 05:15 AM
  5. Have to calculate working hours excluding Weekends,Holidays and NON Working Hours
    By Bob-1383 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2013, 10:45 AM
  6. Date/Time Calculation - cannot use networkday - I have a working formula except holidays
    By gamer39 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2013, 07:45 PM
  7. non-working holidays
    By barkarlo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2011, 06:17 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1