setup formula to calculate random dates

[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.

 

[Guest]

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