View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_68_] Mark[_68_] is offline
external usenet poster
 
Posts: 2
Default 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 ***