Pattern/trend analysis against dates
 

Hi - I have a record of employees lateness and sickness on a
spreadsheet, against a date.

Is there any VBA or analysis addins that I could use to look at the
dates of lateness/sickness in the cells, and advise if there is any
trend (eg. last Friday of each month, Monday after payday etc).

Just something basic which will help draw attention to people who have
patterns emerging?

Thanks for any help,

Mark

*** Sent via Developersdex http://www.developersdex.com ***