date & time filter

  1. I

    How to check if a date range passes through a month

    Dear Excel Community, How can I check if a date range passes through a month and give out the number 1 if it does. Im an intern at a company and every month i have to give a report for the workers council. In this report I have to count the number of interns and bachelor/Master thesis...
  2. H

    The number of days per month that fall between two dates

    Hello all: I want to track and chart the total number of days per month several pieces of equipment are out of service. The insert is just a idea on how I may go about this, it may be inefficient or even not doable, so its not set in stone. I have a start date and an end date that each...
  3. R

    check for startdate and enddate with input startdate and enddate then pull the data.

    Hi there, Here is my example, I got a chunk of data in sheet1 here, it's a task list contain start and end dates for each task. (it's comes from my calendar as power querry so it may fill up any times) ABCD1Start EndMy TaskPriority222/10/202225/10/2022Task 1LOW323/10/202224/10/2022Task...
  4. kelly mort

    VBA code to list the individual dates between two dates

    In the post at: https://www.mrexcel.com/board/threads/vba-advancedfiltering-faling-to-work-after-changing-the-format-of-cells.1192601/ I was looking for a way around getting advanced Filter to work for dates stored as texts in the format "dd-mm-yy". According to @Marc L, it is not a good idea to...
    • kelly mort
    • Thread
    • date date & time date & time filter date & time format date vba finding date vba vba date format vba date from sheet
    • Replies: 3
    • Forum: Excel Questions
  5. alm395

    Filter Report based on Dates

    Attached is an extremely condensed version of a report that I have to run monthly. Yesterday I was asked if the Master page could be filtered based on a date range, instead of the full data from the start date through the date the report is updated. I have added a "Start Date" and "End Date"...
    • alm395
    • Thread
    • date & time filter multiple tabs update reports
    • Replies: 1
    • Forum: Excel Questions

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