Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
54
Views
Topic starter
What is the easiest way to create a new column that displays the financial year from a date column?
eg 1 Aug 19 would be displayed as FY 19/20
Posted : 04/12/2019 11:46 pm
Hi John,
I'm assuming your financial year is July to June, in which case you can use a conditional column. See example file attached.
Mynda
Posted : 05/12/2019 3:12 am
Topic starter
perfect thanks!
Posted : 05/12/2019 7:01 pm
