How Many employees have birthdays in Jan, Feb, ect.

S

SamMaynard

Board Regular
Joined
Dec 4, 2002
Messages
106
This is what I have...
I have employee names in one feild, and there birthdays in another. I want to find out how many employees have birthdays in January, Feb. ect.

So if there are 10 employees with birthdays in Jan, 15 in february and 6 in March the results of a cross tab should look something like this.

Jan Feb March
Count 10 15 6

I can't figure out how to do this. Hope this helps. Eventually this data will need to go in a report.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Sort by date Sort by votes
I don't know how to do it in a query, but you can create three seperate querys.

Jan Feb Mar

Then use three text boxes on your report
DCount("[Last Name]","Jan")
DCount("[Last Name]","Feb")
DCount("[Last Name]","Mar")
 
Upvote 0
Try,

SELECT Format([birthday],"mmm") AS [Month], Count(Format([birthday],"mmm")) AS [Number]
FROM Table1
GROUP BY Format([birthday],"mmm");
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
Year to Date Column (POWER Query)
Replies
2
Views
361
GraH
GraH
B
  • Question
Event code to populate message upon workbook open at specified dates
Replies
2
Views
151
bh24524
B
S
  • Solved
Sum from a table if the key matches a variable array
Replies
3
Views
154
Fluff
Fluff
staticfluids
  • Solved
Dynamic Array Formula (FILTER) But Show the Other Criteria with Blank
Replies
4
Views
471
staticfluids
staticfluids
B
  • Question
Logging First occurrence in calendar year
Replies
9
Views
351
KRice
K

Forum statistics

Threads
1,221,840
Messages
6,162,311
Members
451,759
Latest member
damav78

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top