Display date of that particular work day!

excel
activities

#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 .

https://msdn.microsoft.com/library/system.datetime.adddays(v=vs.110).aspx
https://msdn.microsoft.com/library/system.datetime.dayofweek(v=vs.110).aspx

This is an example FORUM_15397.zip (11.2 KB)

Regards,
Susana