Quote:
Originally Posted by duane_mi
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¦
|
Hi Duane,
I think an example workbook, with no confidential info, would be beneficial here.
If you could show a before and after with some notes on the method behind how the final figures will be reached then you'll get a far better answer, far quicker.
S.