View Single Post
  #1   Report Post  
Grey
 
Posts: n/a
Default Quick date calculation functions

If I have a cell with the number of a month and a year, how can I produce a
formula which will...

1. Return the number of days in that month.

2. Calculate the number of specific days of the week in that month (e.g. how
many Tuesdays in Feb 2006)

If I have two dates, how can I calculate how many working days (mon-fri)
between them?

Thanks in advance,

Graham