Forum Discussion
Calculating aging with multiple columns
Hi,
I'm having trouble with a formula in my aging spreadsheet. I have the 3 columns below and i need aging to track in the 3rd column. Once we submit a change order and input a date in the 1st column, i need for the 3rd column to start the aging, but once a date is entered into the 2nd column, i need the aging to stop counting. I used an "if" statement with today() to make the aging start but i don't know how to stop it when the date is added to the 2nd column. This is what i have so far:
=IF(Today()>=F2,Today()-F2)
Please Help......
| Change Order #2 Feildlens Submission Date | Change Order #2 SLS Approval Date | Change Order #2 Aging for Approval |
| 42962 | ||
| 42962 | ||
| 42962 | ||
| 42962 | ||
| 42962 | ||
| 42962 | ||
| 42962 | ||
| 42962 |
Hi Steve,
If you'd like to find difference in days between approval and submission dates using current date if there was no approval, when like
=IF(G2>1,G2,TODAY()) - F2
Above assuming you have submission date. To check if it exists or not
=IF(F2>1, F(G2>1,G2,TODAY()) - F2, "")
To make column calculatable better to use 0 instead of "" and apply custom format like 0;0;;@ to hide zeroes.
Thank you very much for your help..... I will implement the formulas and see if i can make things work.
