jski21
Board Regular
- Joined
- Jan 2, 2019
- Messages
- 133
- Office Version
- 2016
- Platform
- Windows
Good day Mr. Excelites,
Trying to get the correct fiscal year from a date and am a bit stumped. The formula I'm using is =YEAR(E3)+(MONTH(E3)>=$M$3). Snapshot of the sheet is below:
Cell M3 is not shown in the above but its value is '6.' Fiscal year runs from June 1 - May 31. With that in mind, Cell N3 (and some of the others) needs to read '2017' as the date of 1/29/2018 falls within June 1, 2017 and May 31, 2018. Tried a few iterations but am coming up empty handed (and headed it seems).
Thanks everyone for the direction.
jski
Trying to get the correct fiscal year from a date and am a bit stumped. The formula I'm using is =YEAR(E3)+(MONTH(E3)>=$M$3). Snapshot of the sheet is below:
CD Depts. Charts.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
E | N | |||||||||||
1 | Jrnl Doc Record Date | Fiscal Year | ||||||||||
2 | 12/27/2017 | 2018 | ||||||||||
3 | 1/29/2018 | 2018 | ||||||||||
4 | 1/29/2018 | 2018 | ||||||||||
5 | 1/18/2018 | 2018 | ||||||||||
6 | 1/25/2018 | 2018 | ||||||||||
7 | 6/14/2017 | 2018 | ||||||||||
8 | 1/11/2017 | 2017 | ||||||||||
9 | 1/24/2018 | 2018 | ||||||||||
10 | 1/25/2017 | 2017 | ||||||||||
11 | 2/8/2017 | 2017 | ||||||||||
12 | 2/22/2017 | 2017 | ||||||||||
Master |
Cell Formulas | ||
---|---|---|
Range | Formula | |
N2:N12 | N2 | =YEAR(E2)+(MONTH(E2)>=$M$3) |
Cell M3 is not shown in the above but its value is '6.' Fiscal year runs from June 1 - May 31. With that in mind, Cell N3 (and some of the others) needs to read '2017' as the date of 1/29/2018 falls within June 1, 2017 and May 31, 2018. Tried a few iterations but am coming up empty handed (and headed it seems).
Thanks everyone for the direction.
jski