How to skip weekend(saturday and sunday)

[Ratan Bhushan]

Hey Friends

While draging the date, I want it skips the saturday and sunday date and then carry on with the next weekday which is monday

like
monday 09/06/1986
tuesday 10/06/1986
wednesday 11/06/1986
thursday 12/06/1986
friday 13/06/1986
Monday 16/06/1986
goes on
in different cells

Please help

 

[Somendra Misra]

Hi Ratan,

Try

Your starting day in A1 put below formula in A2 and drag down
=IF(OR(WEEKDAY($A1+1,2)=6,WEEKDAY($A1+1,2)=7),A1+3,A1+1)

Regards,

 

[Ratan Bhushan]

Hi Ratan,

Try

Your starting day in A1 put below formula in A2 and drag down
=IF(OR(WEEKDAY($A1+1,2)=6,WEEKDAY($A1+1,2)=7),A1+3,A1+1)

Regards,

It is just awesome sir

 

[Somendra Misra]

Thanks for the feedback and welcome back!!!

Regards,