Can anyone please help me, I have been scratching my head for ages and looked all over the web and I cannot fathom how to do the formula I need.
I can do a very long multiple if formula, but their must be a better way, maybe combining a VLookup and an If formula.
I have a very large sheet of dates when projects need to start and a diary from our customer.
To report to our customer when this work is done it would be better to have a mechanism to define what year & period that the project falls in (column A).
The formula I would like looks at the date (column B), then by using a formula it looks to see what date range it falls between (columns f & G), then the output finds the correct year & period (column H).