| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to Return a Date Value Q
I looking for a function that will return the value that is in one of
5 cells that is matches the closest to Todays date. Thus - I have 5 date values in cells A5 to E5 Todays date is in A1 In A10 I want to return the value of one of A5-E5 that is closest to todays date that is in A1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howw can I make a function return a date in date format | Excel Programming | |||
| Function to return column where a date is entered | Excel Programming | |||
| Using TODAY function to return a date as text | Excel Discussion (Misc queries) | |||
| Need a function or formulae that will return the current date + 1 | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Threaded Mode
