Forum Discussion
Kory_DeaversUW
Dec 01, 2022Copper Contributor
Return number of Days in Excel if certain criteria met
I have an excel spreadsheet for when expense reports are approved by corporate. I am trying to write a formula that looks at a cell that either has Paid, Approval in Process or Pending in it and want...
OliverScheurich
Dec 01, 2022Gold Contributor
=IF(OR(G2="Approvals in Process",G2="Pending"),TODAY()-D2,"Paid")Does this return your expected result?
Kory_DeaversUW
Dec 02, 2022Copper Contributor