Hi everyone. I need help please. I am trying to create an Excel spreadsheet such as follows in the attached photo. I've already successfully created formulas to calculate the aging days in the appropriate fields. But how can I do the following?
- Make the F column blank if there is either/or nothing in the corresponding C cell or corresponding D cell (keep in mind there is already a formula in the F column).
- Make the E column blank if there is either/or something in the corresponding C cell or corresponding D cell (keep in mind there is already a formula in the F column).
I've spent a majority of my work day today researching and trying to figure this out and I can't get it. Any help will be greatly appreciated.
it is applicable with my problem where i want to stop the count of aging once i put a closed date. currently i use the formula =IF(TODAY()>C8,TODAY()-C8,0) for aging.
