Excel Date Subtraction with Muliple Options

powellku

New Member
Joined
Aug 13, 2020
Messages
12
Office Version
  1. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
1,300
Office Version
  1. 2016
Platform
  1. Windows
Hi Powellku,

So logically “= original date - MAX(x1,x2,x3…x12)”?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,985
Messages
5,599,206
Members
414,296
Latest member
nachname

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top