# cal no of days

#### vishalvijayan

##### Board Regular
Hello,

I know the formula to calculate the number of days in a month.
=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

But can anyone tell em how to calculate the number of days in a month excluding sat & sun.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
=networkdays(date(year(a1),month(a1),1),eomonth(a1,0))

Last edited:
wait nevermind the above formula is correct

Last edited:

Replies
2
Views
165
Replies
4
Views
113
Replies
1
Views
182
Replies
0
Views
318
Replies
11
Views
296

1,202,976
Messages
6,052,876
Members
444,606
Latest member
rwmhr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back