Find closest future date from list ...
 

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

Find closest future date from list ...
 

One other thing ..... paydates would be in another column, say
Z2:Z27 ...

thanks again!

Find closest future date from list ...
 

Hi,

Try formulas below:

in the cell D2: =TODAY()

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

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

Thanks,
--
Farhad Hodjat


"Ray" wrote:

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

Find closest future date from list ...
 

Thanks very much, Farhad ... worked perfectly!