Find closest future date from list ...

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Hi -

I've got a list of 26 dates, each one 2 weeks after the next (these
are pay-days). What I want to do is find the next paydate from
today. Here's the data I'd like to have:
cell d2: today's date (DD-MM-YY)
cell e2: next paydate (DD-MM-YY)
cell f2: days until next paydate

Thanks for your help!

Regards, ray
 
Hi,

Try formulas below:

in the cell D2: =TODAY()

in the cell E2: =MIN(IF(Z2:Z27>D2,Z2:Z27,"")) enter as array formula
Ctrl+Shift+Enter

in the cell F2: =DATEDIF(D2,E2,"d")

Thanks,
 
Back
Top