Finding Final Date in Excel

AkramKhan · #1 Jun 1, 2007, 07:16 AM

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

jstrike · Jun 1, 2007, 08:08 AM

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.

asterisk_man · Jun 1, 2007, 09:49 AM

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



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!