View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Basil Basil is offline
external usenet poster
 
Posts: 60
Default Using Weekday function with no add-ins

Hiya,

I'm creating an excel model for use by a team of staff in my office.

I've included the weekday function for one part of the model to calculate
days where we shift to/from daylight savings.

The team is huge, not very excel literate, and shift worker types. Hence I
don't want to go round installing the analysis toolpack add-in for them all.

Is there anyway I can get the function to work without using the toolpack?
Perhaps by writing a VB function myself? - if so, can you help me with the
code please?

Thanks,

Basil