Forum Discussion
Andrew_Hinson
Feb 21, 2024Brass Contributor
MIN function
Hi everyone, So, In column A I have the dates of 2024 in format ddd-dd-mmm-yy. In column E I have a bank balance, which changes daily depending on what transactions are put into a different ...
PeterBartholomew1
Feb 21, 2024Silver Contributor
A couple of possible 365 formulas
= MINIFS(balance, date, ">" & today)
= MIN(FILTER(balance, date>today))
Andrew_Hinson
Feb 22, 2024Brass Contributor
Hi Peter,
In the same situation as above per my reply to Patrick, but thank you so much for coming back to me and helping 🙂
In the same situation as above per my reply to Patrick, but thank you so much for coming back to me and helping 🙂