I am trying to return start and finish date of events depending on when resources are allocated.
I will be very grateful for your assistance.
Many thanks
I am trying to return start and finish date of events depending on when resources are allocated.
I will be very grateful for your assistance.
Many thanks
please add manualy the desired result in your workbook and refer to the linked cells.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi, this should do what you want. Please note that the start date is given by an array formula. It needs to be entered using CTRL + SHIFT + ENTER nd then copied down.
If this answers your question, please mark the thread as complete and (preferably) click the Add Reputation button at the bottom of my post.
If not - then ask again!
Last edited by Glenn Kennedy; 05-25-2014 at 07:04 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Try these Array Formulas. Since these are array formulas so you need to confirm them with Ctrl+Shift+Enter instead of just Enter. (i.e. after placing the formula in the cell, hold down the Ctrl+Shift and then press Enter)
In N4
and then copy down.Please Login or Register to view this content.
In O4
and then copy down.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks, kaypump. If this answers your question fully, can you mark the thread as "closed"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks