Hi Excel Gurus,
The Objective
I need to subtract the most recent update date from the original date.
The Problem
The basic formula is simple: “= original date – x”. But, “x” could be twelve different dates as there can be up to twelve different updates. Thus the formula should be some like: “= original date – (OR x1,x2,x3…x12)”. My problem is I don’t know how to control for which “x##” excel is going to subtract. For example, if the original date is Jan 1, 2021 and there have been three updates then the data will look as such data x1 = Jan 1, 2022, x2 = Jan 1, 2023, x3 = Jan 1, 2024. I need excel to subtract Jan 1, 2024 from Jan 1, 2021 in order to give me the difference. As for x1 and x2, in this example, I need to keep that data in order to show the trend over time so I can’t just replace the data with the most recent update (x3).
If this is unclear please let me know!
Thank you!
Sincerely,
kp
The Objective
I need to subtract the most recent update date from the original date.
The Problem
The basic formula is simple: “= original date – x”. But, “x” could be twelve different dates as there can be up to twelve different updates. Thus the formula should be some like: “= original date – (OR x1,x2,x3…x12)”. My problem is I don’t know how to control for which “x##” excel is going to subtract. For example, if the original date is Jan 1, 2021 and there have been three updates then the data will look as such data x1 = Jan 1, 2022, x2 = Jan 1, 2023, x3 = Jan 1, 2024. I need excel to subtract Jan 1, 2024 from Jan 1, 2021 in order to give me the difference. As for x1 and x2, in this example, I need to keep that data in order to show the trend over time so I can’t just replace the data with the most recent update (x3).
If this is unclear please let me know!
Thank you!
Sincerely,
kp