days of month

1. Calculate the dates for a specific month where multiple In and Out dates are present

Hi Team, Is there a formula which can get the total number of days between multiple entry and exit days in the same month. I have 6 columns in total and 3 of those are Entry dates and the other 3 are exit dates. Its not mandatory that the entry dates are to be filled nor the exit dates. SO if...
2. How many mondays, tuesdays, etc in a month

Dear all, A new challenge! Can somebody help me with the vba code or formulas for extracting the number of mondays, tuesdays, etc from a specific month in a specific year? i need this information for calculating the amount of delivery days for our clients. Thanks in advance. Regards from...
3. Week Number

I have an excel sheet for paychecks for total hours and i use the weeknumber function to total up paychecks that i should be getting and compare with actual, however the weeknum function that i use i can only get to start on monday or sunday, but i need the week to start over on friday how do i...
4. Day of Week between dates

I am trying to determine how many times a given day of week is in a given date range (as below). Does anybody have an idea of a formula that I could insert into the Sunday, Monday, etc. columns? <TABLE style="WIDTH: 583pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=776...
5. Excel 2007 form problem, Dates

Hi I am trying to make a spreadsheet such that i have a spinner tool at the top of the page, and when all the days of the month in the form dd/mm/yyyy are displayed, and when i click the down arrow it goes to next month so the mm bit of the days changed and no. of days change automatically...

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.

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

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