Chris Waller
Board Regular
- Joined
- Jan 18, 2009
- Messages
- 183
- Office Version
- 365
- Platform
- Windows
Morning All, I am after a little help with a formula this morning to determine a specific date.
On my Spreadsheet In cell E2 there is a dropdown box which contains a number of financial years in the format yyyy/yyyy. The actual data is held on another spreadsheet.
What I would like to do is when I choose a different financial year I would like all the dates in column B to change to the run date for that specific year.
I would like to display in column B the 8th of the month (Starting in April to the following March) OR the first working day after the 8th i.e. excluding weekends and bank holidays.
I have an area below the dates which contains all the bank holidays and I believe I have managed to link this to the dropdown so that when this is changed, the bank holidays change to the relevant year. I just need a little help sorting the formula for the run dates. TIA
On my Spreadsheet In cell E2 there is a dropdown box which contains a number of financial years in the format yyyy/yyyy. The actual data is held on another spreadsheet.
What I would like to do is when I choose a different financial year I would like all the dates in column B to change to the run date for that specific year.
I would like to display in column B the 8th of the month (Starting in April to the following March) OR the first working day after the 8th i.e. excluding weekends and bank holidays.
I have an area below the dates which contains all the bank holidays and I believe I have managed to link this to the dropdown so that when this is changed, the bank holidays change to the relevant year. I just need a little help sorting the formula for the run dates. TIA
