Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Suggestion required
I have a table with the following information
Pay Date End Period 07-09-2006 0809 05-10-2006 0909 02-11-2006 1009 30-11-2006 1109 21-12-2006 1209 What I want to be able to do is enter a date for example 15/11/2006, and it tell me what the end period would be. Therefore it would look for the first higher paydate, in this case 30/11/2006 so therefore return a value of 1109. Many Thanks in advance for your assistance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Relative vs Absolute referencing of Workbooks | Excel Worksheet Functions | |||
Relative vs Absolute referencing of Workbooks | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Rate of return required formula | Excel Worksheet Functions |