AYelverton
New Member
- Joined
- Dec 16, 2004
- Messages
- 3
I am trying to produce a formula that will enable me to determine what period a date falls into within defined 28 day boundries
In column A I have the start date of each period, in column B the end date for each period. In C the period number.
For example
01/05/04 28/05/04 1
In L I have a list of dates that will a random date
In M I wish it to return what period that date falls into (1-13)
Typically I would use a multiple IF statement but as this is not possible for over 8 functions I am struggling to identify what is required
Thanks
Anthony
In column A I have the start date of each period, in column B the end date for each period. In C the period number.
For example
01/05/04 28/05/04 1
In L I have a list of dates that will a random date
In M I wish it to return what period that date falls into (1-13)
Typically I would use a multiple IF statement but as this is not possible for over 8 functions I am struggling to identify what is required
Thanks
Anthony