Dates and network dates

[craig80]

Hello all,

I am currently putting together a resource plan, which will in effect be a Gantt chart to show dates of people in and out of the organisation.

I want to build in a few variables, for which I know there are easy function solutions, just can't get my head around them. So feedback from my ever trusted mrexcel friends would be great.

I have below a sample which isn't pretty, I dont know how to embed a extract from excel.

If I write in sudo code, I hope that it will make sense(the red is where I am looking to put this function, columns F to K are the Gantt).

H3
=IF(D3 falls in month of oct, (and no more than 10 network days between D3 and EOMonth in H), then populate with "KY"&C3) Repeat number of times in column E

Hope someone can help. (even better if someone could point me to directions to include excel shots?)

Thanks
Craig


[TABLE="width: 987"]
<colgroup><col><col span="4"><col span="5"><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]Start or End[/TD]
[TD]Code[/TD]
[TD]Out/In Date[/TD]
[TD]Knowledge transfer[/TD]
[TD]Aug(end dates)[/TD]
[TD]Sept[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]E[/TD]
[TD]EY1[/TD]
[TD]24/04/2015[/TD]
[TD]0[/TD]
[TD]EY1[/TD]
[TD]EY1[/TD]
[TD]EY1[/TD]
[TD]EY1[/TD]
[TD]EY1[/TD]
[TD]EY1[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD]S[/TD]
[TD]P1[/TD]
[TD]07/09/2014[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]KY1+P1[/TD]
[TD]KY1+P1[/TD]
[TD]KY1+P1[/TD]
[TD]P1[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD]S[/TD]
[TD]P1[/TD]
[TD]31/01/2015[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 987"]
<colgroup><col><col span="4"><col span="5"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 861"]
<colgroup><col><col span="4"><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[skywriter]

Excel Jeanie Html

MrExcel.com | Excel Resources | Excel Seminars | Excel Products