Display date of that particular work day!

Help
,
1

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 !!!

2

Hello @moinu,

You can achieve it usign DateTime.AddDays method and DateTime.DayOfWeek .

This is an example FORUM_15397.zip (11.2 KB)

Regards,
Susana

2 Likes