Date Difference Excluding weekends

[#1]

Hi all

I want to be able to see how many working days are letf in a month, for example what I have below is;

But I want to remove the count for the weekend days or even just Sunday if possible.

Any ideas?

I want this as a caculated dimension in a pivot chart. 

=MONTH_END-today()

Thanks

Aidan

[#2]

Thank you kindly, worked perfectly

[sebastiandperei]

Ok, you need only the number of days between 2 dates without the sundays. Try:

/*1*/ =NetWorkDays(Today(),MonthEnd(Today())) +  

/*2*/ Div(Floor(MonthEnd(Today())-Today())+1,7)+    

/*3*/ if(WeekDay(Today())>=WeekDay(MonthEnd(Today())+2) 

/*4*/ and WeekDay(Today())<>6,1, 0)                                            

/*1*/ Days Monday to Friday next

/*2*/ Complete following weeks always have one Sat each one

/*3*/ If weekday(today) is grater than weekday(monthend+2), it means that you have left a weekend plus the complete weeks

/*4*/ With this, you don't plus the Sundays

Sorry if my english is not good.

[sebastiandperei]

Wow Manish, while you are typing this solution, i was thinking about 2 hours in my solution (on Bottom)...  Your one is very simple and "beautiful", but mine is ugly!!!!  I don't want to correct your solution, the time between the answers is because im in Argentina.

Is amazing to keep learning from people like you!!! Thanks.