nearest date

  1. P

    How to find the next nearest time from array to given time

    Hello, I am trying to solve the following problem and your expertise and help would be greatly appreciated :biggrin:: Ho to find the next nearest time from array B5:B36 to date entered by user in E4. (User should enter a time when the freight is ready and formula should pick the next closest...
  2. H

    Reference ID, Then Return Nearest Date from Second Reference

    Hello Excel Community, The Data: <tbody> (A) ID (B) Test Date (C) Test Value (D) (E) Reference ID (F) Reference Date (G) Return Value 10 DD/MM/90 1 10 DD/MM/06 .60 10 DD/MM/05 .60 11 DD/MM/15 10 DD/MM/14 .90 12 DD/MM/08 11 DD/MM/89 .88 13 DD/MM/14 11 DD/MM/06 .90 14...
    • husar
    • Thread
    • index & match nearest date two-columns range lookup
    • Replies: 3
    • Forum: Excel Questions
  3. B

    Matching with a nearest date in a date range?

    Hi All, I have 20,000 dates relating some investment transactions named as DateofInvest and I have some irregular dividend announcement dates named as DateofDividend. When I say irregular sometimes Jan-4th, Feb-13th, Oct-23 etc. What I need to do is, I have to apply all these Dividend dates...

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