I've been racking my brain and unable to solve what I'm sure is very simple!
I am working on a timesheet and I have a list of dates (A) [always present] and start times (B) and end time (C) [which may contain a time or be null/blank] ... In cols D and E I want to display the next scheduled start date and time where an end date is present, and null if end date not specified.
Image.png
I have all sorts of solutions going round in my head (Index Match Offset Row) but am unable to get the logic straight. i.e. Come up with a solution!
Be grateful for some input - Thanks
Bookmarks