Hi Guys!

I am developing a work plan of field officer in which they select month and than cells will auto generate dates (with working days)

i am using this formula in B4 to get first working day
Formula: copy to clipboard 
=WORKDAY(EOMONTH(A1,-1), 1)
this works perfect but now we want that field office will re-visit after 5 days but it is difficult to get working day after 5 days in a specific cell.

i am using this formula to add 5 days
Formula: copy to clipboard 
=B4+5
this is good but it showing Sundays also.

Hope you guys understand

sorry i can not upload sample because of our Office IT restriction.