View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ray Ray is offline
external usenet poster
 
Posts: 267
Default 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