Nicolaf
08-22-2013, 03:01 AM
Hi,
I have a list of dates and would like to have a formula that gives me back the next date from today's date.
So for example list of dates below:
11-Apr-2013
11-Oct-2013
11-Apr-2013
11-Oct-2013
Let's say these dates are found in Cells G5:G8.
I would like to write a formula in cell H5 which gives me back next available value to today so in this case answer would be 11-Oct-2013.
I can put today's value in cell I5 (formula would be =today())
What is best way to do this?
Nix
:think::think:
I have a list of dates and would like to have a formula that gives me back the next date from today's date.
So for example list of dates below:
11-Apr-2013
11-Oct-2013
11-Apr-2013
11-Oct-2013
Let's say these dates are found in Cells G5:G8.
I would like to write a formula in cell H5 which gives me back next available value to today so in this case answer would be 11-Oct-2013.
I can put today's value in cell I5 (formula would be =today())
What is best way to do this?
Nix
:think::think: