+ Reply to Thread
Results 1 to 4 of 4

Reading months and finding a total number of bookings in a month.

  1. #1
    Registered User
    Join Date
    12-13-2011
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    3

    Reading months and finding a total number of bookings in a month.

    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.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,330

    Re: Reading months and finding a total number of bookings in a month.

    Hi Parasanti and welcome to the forum,

    This is a problem that is easily solved using Pivot Tables and counts of dates. See the attached for an example.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-13-2011
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Reading months and finding a total number of bookings in a month.

    Thanks for that, I think its exactly what I needed. I shall try and add a pivot table onto my workbook now.

  4. #4
    Registered User
    Join Date
    12-13-2011
    Location
    Earth
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Reading months and finding a total number of bookings in a month.

    Actually feeling rather silly at the moment. Not sure I properly understand this.

    My dates are arranged like this \1 on either side there is more data but not related to the date. When I set up a pivot table it will read all the dates and list them and say how many there are. I'm unsure on how to actually make it read the month and add how many of a specific type of month there is. In that example you gave there is COUNTIF's in one column which confused me? Sorry for my ignorance on the matter.

    Update: I managed to make it count how many of each exact date there is including days and years. Which is a start, but I really need it into months.

    Update2: Aha! I got it! I had to right click one of the dates and group it. Ahh this is excellent! Thank you so very much.
    Last edited by Parasanti; 12-13-2011 at 02:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1