Hello,

Is there a way in Excel to calculate MDAY (date not including weekend)?

For example:
Ship date = 12/20/07,

I need a formula to calculated 25 days before ship date with weekend date
not counting (5 day a week). Thanks

With shipping date in A1

=WORKDAY(A1,-25)

note that you can put holidays there as well

=WORKDAY(A1,-25,holidays)

also note that WORKDAY is part of the Analysis ToolPak, look it up in help


--


Regards,


Peo Sjoblom



"Cam" wrote in message
...
Hello,

Is there a way in Excel to calculate MDAY (date not including weekend)?

For example:
Ship date = 12/20/07,

I need a formula to calculated 25 days before ship date with weekend date
not counting (5 day a week). Thanks

See WORKDAY() in XL Help.

In article ,
Cam wrote:

Hello,

Is there a way in Excel to calculate MDAY (date not including weekend)?

For example:
Ship date = 12/20/07,

I need a formula to calculated 25 days before ship date with weekend date
not counting (5 day a week). Thanks