For Task2(Teja) we allocated 6days to do work i.e.,(1,2,3,4,5,6)… if Teja started a work from 1st day …I have to display that particular day date in a separate column in that excel sheet only
For EXample: If Teja started work …from 10-10-2017 then for 1stday 9-10-2017,which is monday for 2nd day 10-10-2017 tuesday, for 3rd day 11-10-2017,wednesday for 4thday 12-10-2017Thursday , for 5th day 13-10-2017 Friday,… and skip sat,sunday…and for 6thday 16-10-2017 I have to display the date.
How to do this.pls help me !!!