[Solved]Project Management

[ram8516]

Hi

I have a spread sheet with the following info

cell F5 to AH5 has dates starting from FEB 01 to Feb 29
Cell F7 to AH 7 has number of resources

A 16 has project name
B16 has Estimated hours for the project
C 16 has start date
d 16 has total number of days

I want a formula from f 16 onwards which should first check for the start date at c 16 and then go to the corresponding cell with reference from F5 to AH5 and from that date onwards it should calculate the working days from total number of days and split the resources from cell f7 to ah7 to match the hours from b16 ( 6 working hours per resource).

so for example if i enter project 1 estimated hours as 600 hours and days as 10 and start date as 6th feb. the formula should display 10 resource for 10 working days till 16th excluding sundays.

can any help???

Thanks in advance
regards
Ram

[ram8516]

i used this formula

=IF($D$16="";"";IF($C$16=$F$5;IF(IF(COLUMN(D$16)-3>$D$16;"";$C$16+(COLUMN(D$16)-3)-1)=F5;($B16/$D$16)/$B$2;"") ;""))

now i want is to check the start date only

i want to incorporate a if condition to the above formula to check the start date in c 16 with the dates if f5 to ah7

any help???

[messki678]

ram is exactly right. he solve the issue correctly.
_________________
Test-king cert-MCTTP http://www.test-king.com/cert-MCITP.htm
Exam cert-CCNP http://www.test-king.com/cert-CCNP.htm
Training cert-CCDA http://www.test-king.com/cert-CCDA.htm