Would really appreciate some help on an issue I’ve run into.
I’m building a booking database.
I want to be able to work out how much money I’ve made in a month against a target.
I currently have a table with my booking months in, mapped against my targets:
I pull this via a look up into my bookings table which allows me to manually set the month the booking is made.
I would like to be able to automatically select the option based on the start date - so if a booking is made in June 2020 - It will categorise it in the correct month.
The reason I’m doing it this way round is so I can match it to the monthly target.
Hopefully that makes sense - it feels like there must be a formula I could use to achieve it!
Thanks in advance