Return blank cell only if referred cell is blank but return aging if date is entered

0 votes
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 by Kithuzzz
• 38,000 points
1,627 views

1 answer to this question.

0 votes

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

answered Dec 17, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

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

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

answered Sep 27, 2022 in Others by narikkadan
• 63,600 points
1,047 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,461 views
0 votes
1 answer

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

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

answered Nov 12, 2022 in Others by narikkadan
• 63,600 points
888 views
0 votes
1 answer

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

answered Jan 9, 2023 in Others by narikkadan
• 63,600 points
679 views
0 votes
1 answer

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

answered Oct 8, 2022 in Others by narikkadan
• 63,600 points
1,036 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,600 points
710 views
0 votes
1 answer

Control cell value from another cell in Excel

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

answered Nov 10, 2022 in Others by narikkadan
• 63,600 points
1,406 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 63,600 points
952 views
0 votes
1 answer

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 63,600 points
1,253 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

answered Jan 26, 2023 in Others by narikkadan
• 63,600 points
723 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP