Forum Discussion
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...
= IF(status="Paid", approved-submitted, "Not Paid")
= IF(status<>"Paid", today-submitted, "Paid")
I suspect the formula you require is very similar to that you already have.
The name 'today' refers to a cell containing the formula
= TODAY()