| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select the nearest date from a ranges of dates?
Hello,
suppose you have a range of dates and you would like to select the nearest future date. For exemple, range of possible monthly repayment dates goes from 1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first next possible redemption date should be 1st March. On 24th June, the first possible redemption date should be 1st July. My question is, is there anybody who can explain me how to program such a formula in excel? Many thanks in advance, Gerrit |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I select the nearest date from a ranges of dates?
will this do
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1) -- Don Guillett SalesAid Software "gerrit" wrote in message ... Hello, suppose you have a range of dates and you would like to select the nearest future date. For exemple, range of possible monthly repayment dates goes from 1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first next possible redemption date should be 1st March. On 24th June, the first possible redemption date should be 1st July. My question is, is there anybody who can explain me how to program such a formula in excel? Many thanks in advance, Gerrit |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I select the nearest date from a ranges of dates?
If you future or past dates are in column A, then in column B enter:
=IF(A1-TODAY()<0,9999,A1-TODAY()) and copy down Then sort by column B and take the top entry -- Gary's Student "gerrit" wrote: Hello, suppose you have a range of dates and you would like to select the nearest future date. For exemple, range of possible monthly repayment dates goes from 1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first next possible redemption date should be 1st March. On 24th June, the first possible redemption date should be 1st July. My question is, is there anybody who can explain me how to program such a formula in excel? Many thanks in advance, Gerrit |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I select the nearest date from a ranges of dates?
=MIN(IF(rngTODAY(),rng))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "gerrit" wrote in message ... Hello, suppose you have a range of dates and you would like to select the nearest future date. For exemple, range of possible monthly repayment dates goes from 1st Jan over 1st Feb to 1st December. Today it is 12th Feb so the first next possible redemption date should be 1st March. On 24th June, the first possible redemption date should be 1st July. My question is, is there anybody who can explain me how to program such a formula in excel? Many thanks in advance, Gerrit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I select from within a range of dates? | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| How do I show dates older than present date? | Excel Worksheet Functions | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
| Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Linear Mode
