daycount

  1. S

    VBA Paste to Dynamic Column Address

    Prior to my problem area, I receive two dates from a form which I then determine the difference between them. Dim dayCount As Integer dayCount = DateDiff("d", Date_Selection.sDate.Value, Date_Selection.eDate.Value) On my worksheet I need to take the formula that resides in "J2" and...
  2. T

    VBA UDF to count # of weekend days and holidays between 2 dates

    Need some help to figure this out. It is basically the opposite of networkdays, my UDF will count how many days in a date range are weekend days and holidays. Public Function NonWorkDays(StartDate As Date, EndDate As Date) As Long Dim wb As Workbook Dim wsList As Worksheet Dim...
  3. A

    Counting days with multiple split ranges

    Hi to all professionals :) Need your professional help to put the below query in to excel formula please. Basically i have two dates on the left of the table, which is input from user, i need to calculate the number of days between period split mentioned on the right of the below table...
  4. C

    Excel function to determine how many days in year YYYY

    Hello, I need to determine whether my daycount should be 365 or 366 depending on the year. For example in 2016 it was 366 and in 2017 it's 365. Is there a function which will do this? Thanks, Clare

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?

Disable AdBlock

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
Back
Top