Forum Discussion
jaolvera
Jun 07, 2023Brass Contributor
IF formula
Hello, I needed a formula that would reference one of 2 dates. so if column Q contains "Yes" then reference the date in column R, or if Column Q contains "No" then reference date in cell O. Thank you...
jaolvera
Jun 07, 2023Brass Contributor
it references "1/0/1900" when I did the formula. Patrick2788
Patrick2788
Jun 07, 2023Silver Contributor
- jaolveraJun 07, 2023Brass ContributorActually it worked, I had wrong cell referenced. thank you again!
- Patrick2788Jun 07, 2023Silver ContributorYou're welcome!