| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The closest "specific day" to a specific date.
In this case (of course the day will change in some cases) I want to know
what is the the closest "thursday" from a specific date. In A1 i have 10/14/08.... in B1 i have "thursday"..... In C1 i want to know which is the closest Thursday from A1.. The answer to this should be 10/16/08.. Is there a formula for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a specific figure i.e 0:00 and 24:00 to display as "MIDT" | Excel Discussion (Misc queries) | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| copy specific rows using "IF" to another sheet | Excel Worksheet Functions | |||
| Find specific number and replace with "Yes" | Excel Discussion (Misc queries) | |||
| "Extract" specific values from cells | Excel Discussion (Misc queries) | |||
Threaded Mode
