View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N Ramsay N Ramsay is offline
external usenet poster
 
Posts: 11
Default UDF: How many Monday's in a date range?

Hi,

Newbie help needed please

I need to write 5 UDF's in Excel.

They are all similar, so let's explain the first one.

I'll pass in 2 parameters: "startdate" and "enddate".

I want to calculate the number of Mondays that exist in the date range
between startdate and enddate, and pass it back.

The other 4 UDF's are for Tues, Wed, Thurs & Fri.

Any thoughts please?

Kind Regards,

NR