Hello,
I'm working on the attached sheet and want to be able to capture upcoming due dates based on today's date. I've tried the MIN function and can't seem to get it to work as the date returned is in the past (M5), rather than >= in the future. I would also like to be capture due dates sequentially, so (M5) would capture the first upcoming date, followed by next in (M6), etc., through (M15).
I'm working on the attached sheet and want to be able to capture upcoming due dates based on today's date. I've tried the MIN function and can't seem to get it to work as the date returned is in the past (M5), rather than >= in the future. I would also like to be capture due dates sequentially, so (M5) would capture the first upcoming date, followed by next in (M6), etc., through (M15).