| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find closest match and copy | Excel Discussion (Misc queries) | |||
| How can I match a calculated date to closest date from a list? | Excel Worksheet Functions | |||
| finding a date/time in a list that is closest to an existing date/ | Excel Discussion (Misc queries) | |||
| How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
| How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) | |||
Threaded Mode
