Forum Discussion
Solved
Auto Populating Fiscal Year in a Cell Based on a Date Entered in Another Cell
Hi everyone. I’m working on a database and am trying to figure out how to make a cell auto populate with a fiscal year (ie 2022/2023) based on a date that’s entered in the preceding cell. The date th...
Let's say you enter a date in A1.
The fiscal year is returned by the formula
=YEAR(EDATE(A1,-6))&"/"&YEAR(EDATE(A1,6))
Let's say you enter a date in A1.
The fiscal year is returned by the formula
=YEAR(EDATE(A1,-6))&"/"&YEAR(EDATE(A1,6))
- Nice job. Cleaner, shorter than mine.
Thanks, John!
- Thanks!
Just for fun, though, given that I've already marked Hans's reply as the best response, I thought this was a great situation to write a LAMBDA function. So in my revised sheet, attached, you can just enter a date in, say, cell A4, and then in any other cell,
=Fiscal(A4)
to get the corresponding Fiscal Year.
If LAMBDA functions are new to you, here's a reference that explains how to do them.
