View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 59
Default cal number of days

Hello,

I am wondering if excel has a function to do this:

I have created a work plan in excel.

And I have an end day. Let's say Oct 31 2004

Can I enter that in 1 cell? Then have a calculation that will give me the
number of work days (mon-fri) between the current day and that day.

I can just have another cell with the number of holidays. And just subtract
that amount.



Thanks in advance