exclude dates

  1. C

    Points fall off after 365 days

    I am attempting to get absentee points to fall off after 365 days. My sheet has a row with the date. A row with the points. I have it totaling the points in the row but want the points to not be included if its been 365 days. My formula does not work...I have attempted multiple variations with...
  2. R

    Calculating future date excluding Public Holiday, Weekends and Backdate specific date

    Hi. Im trying to calculate TAT from today, excluding public holiday, weekends and specific date. Assume today's date - 18/06/2024 For example 60 days from today - 08/07/2024 However for that date, employee has an approved leave and unable to attend the task on that date And we cant extend the...
  3. alm395

    How to count date range while excluding dates

    Hi, I have a storm report that we have been running since 2/1/19 that basically tracks the number of incidents that occur each day. This is a sample from the report (top row is the column they are in): <tbody> G M T U Date Time frame Month Blue Sky / Storm <tbody> 2/1/2019 09:50:14...
    • alm395
    • Thread
    • countifs date & time exclude dates report total
    • Replies: 3
    • Forum: Excel Questions
  4. A

    Sum numbers in a column , exclude date value

    Hello All I would like to sum all figures in a column using SUM function but it tend to sum the dates in as well. Any advices to exclude the dates? Tried using ISNUMBER() but realized dates are actually recognized as number value. Note: Sum entire column due to uncertain number of rows to be...

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