I am trying to calculate a date field but it looks like i will need multiple IF's can anyone give me a hand.
The columns i have are shown below i will always have a pending value (in a date/time format)for a request generated by the system. I want to be able to calculate how long it has been pending to todays date. I will then break them down by open for 1 day, 5 days or 10 days. If any of the other fields are populated the system will update them and i will need to subtract them from Pending to get a completed cancelled or authorised time.

Cancelled¦Authorised¦Complete¦Inprogress¦Pending¦