View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Excel Count Weekdays Formula

=workday(A1,12)

This is part of analysis toolpak (Tools=Add-ins=Analysis Toolpak)

HTH

"Ziggy M" wrote:


I need a Formula that will count weekdays only For Example

A1-7/13/06

I am going to need 12 days to complete the task so in another cell i
want it to only count 12 working days (monday to friday) and display
the result in cell c1

any help ?


--
Ziggy M
------------------------------------------------------------------------
Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338
View this thread: http://www.excelforum.com/showthread...hreadid=561241