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 col...
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.
