eligibility

  1. A

    Complicated formula giving

    Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...
  2. J

    Identifying overlapping date ranges with single criteria

    Hi All, I have a single table query containing rows of members identified with a member number and their eff date and end date. There are members in this table with the same member number whose date span on one row overlap wit their date span on another row. I am trying to identify these...
  3. C

    Eligibility - need to build a physical presence calculator

    Hello, my wife and I are in the process of emigrating from the UK to Canada and I'm trying to build a spreadsheet that will calculate in real-time when we're eligible for Canadian Citizenship. To qualify, you need to have spent 1095 days (3 years) out of the previous 5 physically present in...

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