Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
76
Views
Topic starter
I am working on a table that spans may years and I will continue to add to it but I need to have the invoices calculated by Fiscal 4-5 year. I have tried to do this using a formula but I get you have been getting errors or have ben getting a false result back. I have also tried to do this by grouping manually but any new invoices I add are left out on their own. I have attached a sample of my master list, please tell me what I have wrong.
Posted : 25/11/2020 8:06 pm
You can use Power Query to map dates to a 4-5-4 calendar or formulas to convert dates to 4-5-4 calendars. Either way, you need another table that contains how the dates map, as you'll see in the tutorials linked to.
Mynda
Posted : 25/11/2020 8:12 pm
