Hi All,
I am a new member in this community. I am working on a small project in Excel and I am stuck up before I start. My problem is: In my company employees are allowed to choose all the weekdays to work or they can work how many ever days they want in a week. So please imagine that an employee choose to work only on Monday and Thursday. If his first working day falls on 06/01/07(monday or thursday), I want to know what would be the date on the seventh working day. Example, Monday 1, thurday 2, Monday 3, Thursday 4...

How can I achieve this task please assist me.

Tthanks

Lets say the cell A1 is formatted as a date with the start of their first working day.
A1=5/31/2007
In cell A2 you would simply put +A1+7 and that will add 7 days, the date will display properly as 6/6/2007.

HTH.

Can you accept VBA script or are you only interested in spread sheet formulas?