I'm attempting a formula for ageing. I have one column that lists the dates I've provided the information, however, some of the rows in the column are empty. I want to include an ageing formula in a different column. I want the ageing cell to be empty if the "submitted date" cell is empty. I want it to display how many days have passed since it was submitted if a date was supplied.

I haven't used Excel formulas that much yet. I am aware of how to produce ageing and how to make one cell blank if another is already empty. However, I am unsure of how to integrate the two formulas into a single cell.
Dec 17, 2022 in Others 116 views

## 1 answer to this question.

Try this:

`=IF(ISBLANK(AC2),"",TODAY()-AC2) `

The TODAY  function automatically refreshes based on the time on your computer. Change TODAY() to a cell reference where a specific date is supplied to have control over the reference point that the calculation uses (and where it can be changed to suit).

• 53,520 points

## IF formula to compare a date with current date and return result

You can enter the following formula in ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...READ MORE

## Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

## INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX(\$I\$2:\$I\$26,MATCH(V4,\$R\$2:\$R\$26,0))) The calculation ...READ MORE

## Control cell value from another cell in Excel

You may accomplish this by using two ...READ MORE