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
• 28,900 points
116 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
• 53,520 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
• 53,520 points
138 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
• 53,520 points
89 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
• 53,520 points
119 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 in Others by narikkadan
• 53,520 points
41 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
• 53,520 points
163 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
• 53,520 points
129 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
• 53,520 points
98 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
• 53,520 points
141 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
• 53,520 points
73 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 in Others by narikkadan
• 53,520 points
47 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