| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return financial period if value between 2 dates
I have the following table set up on sheet2
Periods Start End 1 1-Apr-06 20-Apr-06 2 21-Apr-06 18-May-06 3 19-May-06 15-Jun-06 etc. On sheet 1, when the date is entered in Column A, I want a function in Column B to show what financial period that date would be in. i.e. A B 05-10-2006 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup dates, fiscal period table | Excel Worksheet Functions | |||
| Counting dates greater than a certain time period | Excel Worksheet Functions | |||
| Period to Period percentage change? | Excel Discussion (Misc queries) | |||
| I really need help! Changing work period start dates | Excel Worksheet Functions | |||
| updaing dates in financial manager wizard | Excel Discussion (Misc queries) | |||
Threaded Mode
