This is hard to explain, so please bear with me. Using Numbers, I want to calculate a specific date by subtracting a given number of days from a constant end date. For example, what date is 42 days before June 20, 2025. Is that possible?
[Re-Titled by Moderator]
iPhone 14 Pro, iOS 18
Date functions can be tricky, but this one's actually easy
Assuming you have a valid date in your cell, you can just add a number to/from it and Numbers will interpret that as a number of days:
A2= 1/1/2025
B2=A2-42 => 11/20/2024 (42 days before A2)
Either the start date or the offset can be references to other cells on the sheet.
If you want finer controls you can use DURATION() to calculate an offset of any number of weeks, days, hours, minutes, seconds, and milliseconds, but that sounds like overkill here.
Date functions can be tricky, but this one's actually easy
Assuming you have a valid date in your cell, you can just add a number to/from it and Numbers will interpret that as a number of days:
A2= 1/1/2025
B2=A2-42 => 11/20/2024 (42 days before A2)
Either the start date or the offset can be references to other cells on the sheet.
If you want finer controls you can use DURATION() to calculate an offset of any number of weeks, days, hours, minutes, seconds, and milliseconds, but that sounds like overkill here.
Well, that was easy! Thank you for saving me many hours and headaches!
How to calculate a date 42 days before June 20, 2025 in Numbers?
