Autofill networking days dates with variable start and end date

[Mengo85]

Hi all,

I cannot believe nobody needed this in the past. I have been researching extensively but no success.

Please find attached an excel file with the desired output in tab "output".

I am looking for a VBA code which autofills cells in tab "Output" with dates without holidays and weekends.

The start and end date can be found in tab "input" B2 and C2, respectively. The holidays can be found in column B:B in the tab "holidays".

The start date must be place in tab "output" D2 and the follwing dates always one column further to the right.

The range of the dates is variable debending on the end date.

Ideally I'd like to have the weekday in row 1 corresponding to the date in row 2. But that is a nice-to-have.

Thanks in advance for all your help.

Seb

[AliGW]

LOTS of people have asked for this sort of thing before and it can be done with a formula - no need for VBA. Interested?

Please check that your profile is up-to-date - are you still using Excel 2010?

[AliGW]

For anyone interested, in Output D2:

=Input!B2

In Output E2 and copied across as far as you wish:

=IFERROR(IF(WORKDAY.INTL(D2,1,1,Holidays!$B$3:$B$5)<=Input!$C$2,WORKDAY.INTL(D2,1,1,Holidays!$B$3:$B$5),""),"")

In Output D1 and copied across as far as you wish:

=IF(D2="","",TEXT(D2,"ddd"))

[kvsrinivasamurthy]

Try this. In D4 copied across.

Please Login or Register  to view this content.

[AliGW]

Thanks for the rep.