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

1. 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

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

which attachment...

3. 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

4. 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

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