+ Reply to Thread
Results 1 to 4 of 4

Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes

    Dear Experts

    i am looking for formula to fill the dates horizontally column wise depends upon cell values filter dates from start to end dates of month

    if i select start date from 01-mart-2015 to 31-mar-2015 if b4 = yes then include sat and sun if b5 = yes then include sat only if b4 and b5 is = NO Then fill dates with out sat and sun till end of 31-ma-2015

    it will get change depends upon select of months from to cell.

    find the attachment you may understand easily
    Attached Files Attached Files
    Last edited by breadwinner; 05-03-2015 at 12:54 PM. Reason: attachment

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes

    which attachment...

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes

    Have a look on the file attached: in blue the display
    The formula is long to limit the display to the end date
    Attached Files Attached Files
    - Battle without fear gives no glory - Just try

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes

    I have this so far for Yes/No sat and sun...
    E3=IF($B$4="no",IF(WEEKDAY(B3,2)<6,B3,B3+8-WEEKDAY(B3,2)),B3)
    F3=IF($B$4="no",IF(WEEKDAY(E3,2)<5,E3+1,E3+8-WEEKDAY(E3,2)),E3+1)
    copied across.

    Still working on Sat = Yes
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 0
    Last Post: 02-10-2014, 10:54 AM
  2. [SOLVED] I want to fill the table with corresponding data depends on user selection in the drop dow
    By maruthi_ravi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-13-2013, 06:23 AM
  3. [SOLVED] fill column with vlookup formula to other workbook that depends on cell value
    By knick12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2012, 03:11 AM
  4. Using VBA to fill col with dates based on start and end date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2011, 11:58 AM
  5. Cell fill colour depends on which radionbutton was selected.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2010, 10:49 AM

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