Hi All,
I know there is a way just can't think of the formula
As shown below I have formulas that returns a date in Cell F12 if sees the first 250 in row 11. As 250 comes up often I need to capture in cell G12 the next date (In this case it would be 14-Aug-23) after cell F12 is populated
I.E, Formula looks at F12, see it has a date in it, so returns the date of when the next 250 come along. in this case it should return 14-Aug-23
Hope this makes sense
I know there is a way just can't think of the formula
As shown below I have formulas that returns a date in Cell F12 if sees the first 250 in row 11. As 250 comes up often I need to capture in cell G12 the next date (In this case it would be 14-Aug-23) after cell F12 is populated
I.E, Formula looks at F12, see it has a date in it, so returns the date of when the next 250 come along. in this case it should return 14-Aug-23
Hope this makes sense