01/07/2018

  1. L

    countifs problem

    <colgroup><col><col><col></colgroup><tbody> Name last visit more booked John 01/01/2019 1 John 16/01/2019 John 01/07/2018 1 Chris 01/07/2018 Chris 01/08/2018 1 Chris 01/01/2019 </tbody> looking for formula to count if active person within 30 days or if more that 30 days but...
  2. A

    Calculate year to date budget for variable contract length

    Hello Everyone. I wonder if someone can help me formula with a formula to calculate the year to date budget with a variable length of contract please The financial year starts from 01 of April and ends on 31st of March. It should look like below. Any help will be really appreciated...
  3. J

    Syntax Help - Sumif and AND

    Hi, Can someone tell me how to cross reference a sumif / countif using an AND for 2 criteria. I want to say if the NAME = John and the DATE = 01/07/2018 then sum. My names are in the column and the dates are in rows. Can someone help with the syntax. Cheers, John
  4. M

    "n" unique random dates between date range, excluding weekends and a list of public holidays

    Hi all, This problem has had me stumped for a while now. I'm looking for a formula to produce unique random dates between a date range, excluding weekends and a list of public holidays (different for each year). Like a lottery, once a date has been selected, it shouldn't be used again. My...

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