dates date range

  1. Jyggalag

    Formula to calculate between dates

    Hi all, I have an overview that looks like this: Days since beginning / ended? Start date End date 01-10-2019 01-11-2023 01-10-2017 01-11-2025 01-10-2018 01-11-2028 01-10-2016 01-11-2021 01-10-2015 01-11-2018 And in Excel: I want to create a formula in column A that...
  2. P

    Best Formula or VBA to Highlight range of dates on a Calendar?

    Hello Friends, I'm trying figure out the best way to highlight the users Days Off on a calendar based off of their selection of dates. So on Sheet1 I have a Calendar and on that same sheet I have a Form control spinner for the user to select a Letter B thru J and on sheet2 starting at Row...
  3. C

    return number based on 3 date entries - but one can have empty values

    Hi everybody, I am using power pivot 2016 on windows 10 enterprise. I have a data model an one of the sheets is a back order list. In this sheet I have the order creation date, the customer delivery wish date and the supplier (to us) confirmed del. date. If the supplier has not confirmed this...
  4. T

    Extract / copy data from another sheet based on date range

    I have a sheet (Sheet 2) with a start date in cell A1 and an end date in cell B1. In another sheet (Sheet 1) I have a list of data, including dates in Column A and data in Columns B, C & D. Most of the dates in Column A are repetitive based on data value in Columns B, C & D. I need to copy...
  5. B

    Calculating with dates

    I would like to do the following: Example data: I have a lease entered into on 10 November 2004 and which finishes on 10 May 2006. Monthly rental is $100. There are lots of leases all at different times/years etc. How can I calculate how much was due per year, i.e. in 2004, 2005, 2006? I...

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