IF statement

[CEBUBUM]

I am just a very old dog trying to learn new tricks and I need some help please.

I have a spreadsheet with four (4) columns of interest

C3 TODAY()
D8 Date Reported
H8 Date Closed
I8 Aging

I want to show aging based on reported date and current date as long as the item is not closed. Once a date is entered into the (H3) date closed cell, I want it to stop updating and show the aging up until it was closed.

I would appreciate any help and would really appreciate an explanation to go with the solution.

Best regards

[Ace_XL]

In I8 use

=IF(H8="",TODAY()-D8,H8-D8)

[rvasquez]

Try this in cell I8:

=IF(H8="",C3-D8,H8-D8)

states that if cell H8 (Date closed) contains not date then cell I8 is equal to the number of days between todays date (C3) and the date reported(D8). If H8 does contain a value the cell I8 is equal to the number of days between the date closed (H8) minus the Date Reported (D8).

[CEBUBUM]

rvasquez,

Thank you for such a clear explanation. I actually understand it now. Just hope I can remember it.

Thanks again

[CEBUBUM]

Thank you Ace_XL. I do appreciate the assistance.