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

Using Weekday function with no add-ins
 

WEEKDAY( ) is a standard function - no need to install the ATP add-in.

Hope this helps.

Pete

On Apr 30, 3:46 pm, Basil wrote:
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

Using Weekday function with no add-ins
 

hi Basil

Weekday is a normal function, not a ATP function
No need to install the add-in


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Basil" wrote in message ...
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

Using Weekday function with no add-ins
 

BUT...
If, at some point, you needed to have the Analysis Toolbar active in a
workbook that you are distributing (for example, to use the EOMonth( )
formula), to activate it, put this in the 'ThisWorkbook' Open procedure of
your workbook...

Private Sub Workbook_Open()
On Error Resume Next
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Basil" wrote:

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