multiple date ranges

  1. M

    HELP IDENTIFY ORIGINAL START DATE BASED ON CONTINOUS SERVICE RULES

    Hi, Employees are often rehired and I need to determine which start date to recognise as 'continuous service' for the purpose of service awards. Prior start dates are only recognised as continuous where the break in employment is 90 days or less. I need to determine which start date to...
    • mrshuck
    • Thread
    • date & ranges multiple date fields multiple date ranges start and end years and months (easy)
    • Replies: 0
    • Forum: Excel Questions
  2. J

    Conditional formatting to highlight multiple date ranges in column calculating from today

    I have a column in excel of multiple dates and some blanks, I need to highlight the cells different colors based on their date range calculating from Today. Example, cells with no date a certain color, cells older than 1 day but less than 6 months a certain color, cells older than 6 months but...
    • JacqueM
    • Thread
    • conditional format help date range formula multiple date ranges
    • Replies: 3
    • Forum: Excel Questions
  3. D

    Vlookup and comparing two date ranges

    Hi guys, I often search this forums for advice for issues, you guys have been great. Today I come to you with my own problem. \ My goal is to fill in 'Number of days' using a Vlookup function with the number of days from Date sheet 2. Still not sure what the best way to do it is, either...

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