How to define a formula which ignore a specific day ?

[VICTOR55]

hi to all experts,

Here I tried several ways to define a formula which ignore the Friday which is my holiday & show me date which come after that Friday.

For example :

5-Nov-2015 is a Thursday & when I drag it I want to see 7-Nov-2015 instead of 6-Nov-2015 because of Friday.

for reference i attached a excel sheet.

waiting for your valuable feedback.

thanks......

[BadlySpelledBuoy]

For one way to do this, put the below formula in cell L8 and drag to the right.

=IF(WEEKDAY(K8+1)=6,K8+2,K8+1)

BSB

[Tony Valko]

This formula entered in L11:

=WORKDAY.INTL(K11,1,16)

Format as Date

Copy across as needed.

[VICTOR55]

thanks.....BadlySpelledBuoy

my post has been solved but i dont know from where to make this option visible.

can you please help me in this regard.

thanks.....