setup formula to calculate random dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
I am trying to setup a formula to calculate employees terminated each months.
I hate doing this and it sucks.
I have a employee spreadsheets and it contains all the users (hire date,
termination date). the data is enter in different columns.

At the end of the month, I need to know how many employees are teminated.
I have another column by months (Jan, Feb, .... December)
I need to calculate how many people were layed off each month.

Thanks for all your help.
 
Try Sorting by the Month Column and then using Data | Subtotals to Count the
Entries in the Terminated Column every time the Month Column changes.

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Dates 3
Expanding Date formula 1
Calculating an age at a certain date 4
Recognizing specific dates with formula 2
Excel Help with dates 2
Formula to calculate elapsed dates. 2
Formula to sum up the dates 10
calculate number of months 2

Back
Top