Quattro Pro vs Excel

[James Marshall]

Quattro Pro has a function called Abday, which allows you to count days not
including weekends, does Excel have a similar formula? Or does anyone know
how I could create one?

[Roger Govier]

Hi James

Take a look at Networkdays. You need to load the Toolpak Addin.
Tools>Addins and check Analysis Toolpak

=NETWORKDAYS(Startdate,enddate,holidays)

Regards

Roger Govier


James Marshall wrote:
> Quattro Pro has a function called Abday, which allows you to count days not
> including weekends, does Excel have a similar formula? Or does anyone know
> how I could create one?