Work Week Date Calculation

Hi,

I've been stuck on this problem longer than I expected and am reaching out for help.

I am working on a project planning spreadsheet where I am inputting planned effort in work days, and a start date, and I want to calculate the end date. The tricky part is that I am only inputting work days, and not weekends. I am also using a work week format to express the dates, so Tuesday July 1, 2014 would be expressed as 27.2 because it is the 27 week of the year and Tuesday is the 2nd day (assuming Monday is the 1st day).

An example of what I expect to achieve is below:

TASK	EFFORT (input)	START DATE (input)	END DATE (output)
Task A	3	24.1	24.3
Task B	3	24.5	25.2
Task C	20	25.3	29.2

Anyone have a suggestion or even better, the universal formula I could use to get the correct result?

Thanks in advance!

I thought I would include this in case it is helpful to solve my problem. If you want to calculate the calendar date from the week.day format you need to use the following equation: =((C2-(MOD(C2,1)))*7)+(MOD(C2,1)*10)+DATE(2014,1,1)-10
This will give you the result 06/09/14 for 24.1.

	A	B	C	D
1	TASK	EFFORT (input)	START DATE (input)	END DATE (output)
2	Task A	3	24.1	24.3
3	Task B	3	24.5	25.2
4	Task C	20	25.3	29.2

I figured it out. It was quite simple. I just didn't know those formulas existed in excel.

Calculation of calendar end date given calendar start date and days effort: =WORKDAY(calendar_start_date, days_effort-1)
Conversion of week.day format given calendar end date: =WEEKNUM(calendar_end_date)+((WEEKDAY(calendar_end_date)-1)/10)

I guess I just needed to talk through it to figure it out...