- Jul 7, 2021
- Office Version
My formula for displaying the last date kind of works. However, if there are no "AC" values in column B, then it returns a 00/01/1900 value. How can i amend the formula below to show some text in this case?