neodjandre
Well-known Member
- Joined
- Nov 29, 2006
- Messages
- 950
- Office Version
- 2019
- Platform
- Windows
I have this setup
COL A - COL B - COL C
F1 - 01/01/2016 - 31/02/2016
F2 - 01/01/2017 - 31/02/2017
F3 - 01/01/2018 - 31/02/2018
F4 - 01/01/2019 - 31/02/2019
For a specific date that falls within a given period, i wish to return the relevant reference. F1, F2, F3, F4
So e.g. for 30/03/2017 the formula should return F2.
Any help would be much appreciated.
COL A - COL B - COL C
F1 - 01/01/2016 - 31/02/2016
F2 - 01/01/2017 - 31/02/2017
F3 - 01/01/2018 - 31/02/2018
F4 - 01/01/2019 - 31/02/2019
For a specific date that falls within a given period, i wish to return the relevant reference. F1, F2, F3, F4
So e.g. for 30/03/2017 the formula should return F2.
Any help would be much appreciated.