Dec 30 2021 11:35 PM
=IF(A31=TODAY(),COUNTIF('TRUST OVERVIEW'!$P$17:$P$192,"B"),"")
above is formula that works only if the A31 matches todays date, however the day after the the data result clears ( obviously because the dates no longer match ) but i want the result to stay.
I am trying to ask it to perform a task on a specific date, A31 could be next weeks date and it will stay blank until then, but when the dates match it performs the task/calculation however the next day the cells clear, how do i get it to leave the result in after the date match.
Dec 30 2021 11:53 PM
SolutionJan 04 2022 01:47 AM
Dec 30 2021 11:53 PM
Solution