Hi All,
Does anyone ever get to that point where you're working on Excel for so long that you forget how to put together a simple formula? Well, I think I'm at that point.
With reference to the attached, I have a string of periods. Each period has a start date and end date. The start date of the second period is the day after the end date of the first period and so on. Each period has a value assigned to it.
What I need is to create a formula in cell G4 that checks which of the periods that the date in cell F4 falls into, then returns the value for that period. I'm getting Excel block here; I know how to do this using long code, but I was hoping to create a very short code that basically references columns as opposed to a cell range i.e. date in F4 must be greater or equal to date in column B and also less than or equal to date (on the same row) in column C.
Bookmarks