I am creating a system in the latest version of Excel which can store bookings amongst other things. Now each booking has a date formatted as Day/Month/Year in a single cell. I know I can use the MONTH formula to find out which month is in a certain cell however I wish to read every cell in the Date column and then return in another table the amount of bookings which are in a particular month.
I would like to do it using formulas over using actual VBA code. Then once I have a table that lists the amount of bookings in each month I will add a graph which will display the amount bookings in a month. For the moment all the bookings are set for next year(2012) however it would be even better if I could maybe separate it even more so it will do it by month and year? or is that too much I am unsure.
Thanks for any information I have tried searching around and so far I have seen nothing like this so I am a little worried I am going too far.
Bookmarks