Thread: cal number of days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default cal number of days
Hi
try
=NETWORKDAYS(TODAY(),A1)


--
Regards
Frank Kabel
Frankfurt, Germany


greg wrote:
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

Reply With QuoteReply With Quote