Trying to create a formula that returns that start and finish date from a resource chart

[superskull2]

Please can someone help, I am trying to create a formula that returns the start and finish dates from a resource chart. If you look at the attached workbook and the yellow cells I have shown what the first resource should return as a start and finish date. However I am unable to create a formula to do this. I have seen it done before but I can't seem to get it to work. Please can anyone help. Many Thanks. Russell

[FlameRetired]

Hello superskull2. Welcome to the forum.

Try in C6 and fill down.

Please Login or Register  to view this content.

and in D6 and fill down.

Please Login or Register  to view this content.

Returns this:

	B	C	D
5	NAME	Start Date	Finish Date
6	Megan	Jul-20	Jan-21
7	Lauren	Aug-20	May-21
8	Callum	May-20	Jun-21
9	Sarah	Jun-20	Nov-20

[FlameRetired]

When you say you want a formula do mean instead of the two I proposed above?

If so try this in C6 and fill down and across

Please Login or Register  to view this content.

[superskull2]

Hi FlameRetired,

Many Thanks for your prompt response and many thanks for welcoming me to the forum. I copied the formula into the Cells and didn't get the dates as you have got. Have I done something wrong?

Many Thanks.

Russell

[FlameRetired]

duplicate post removed by FR.

[FlameRetired]

Your profile says office 365. Is that the version you are applying the formulas to? The embedded '@' in the formulas suggest not. If not you may have to array enter those formulas (after removing the '@'s).

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

[superskull2]

Apolgies, my works computer is 365 the one I have opened this file is not. Its working perfect now.

Many thanks for your help. Really appreciated.

[FlameRetired]

You are welcome. Glad it helped. Thank you for the feedback and added rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.