Simple date subtraction excel
Solved
Eagleeyes011
Posts
27
Registration date
Tuesday February 8, 2022
Status
Member
Last seen
May 28, 2024
-
May 21, 2024 at 04:27 PM
Tbonekiller Posts 17 Registration date Wednesday August 21, 2019 Status Member Last seen June 6, 2024 - Jun 6, 2024 at 01:44 PM
Tbonekiller Posts 17 Registration date Wednesday August 21, 2019 Status Member Last seen June 6, 2024 - Jun 6, 2024 at 01:44 PM
Related:
- Simple date subtraction excel
- Excel date format dd.mm.yyyy - Guide
- Hard disk diagram simple - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
3 responses
vcoolio
Posts
1410
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 23, 2024
262
May 22, 2024 at 12:44 AM
May 22, 2024 at 12:44 AM
Hello again Sean,
You may only need something like this:-
=DATE(YEAR(TODAY()) - 5, MONTH(TODAY()), DAY(TODAY()))
to display a date from five years ago.
Test it in any cell within your workbook.
I hope that this helps.
Cheerio,
vcoolio.
vcoolio
Posts
1410
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 23, 2024
262
May 23, 2024 at 01:20 AM
May 23, 2024 at 01:20 AM
You're welcome Sean. I'm glad to have been able to assist again.
Cheerio,
vcoolio.
Tbonekiller
Posts
17
Registration date
Wednesday August 21, 2019
Status
Member
Last seen
June 6, 2024
Jun 6, 2024 at 01:44 PM
Jun 6, 2024 at 01:44 PM
=IF(INT(YEAR(G1)/4),+G1-(5*365)-2,+G1-(5*365)-1)
G1= creation date of file or =now()
I haven't seen your other file, but if you have a master sheet with all the creation dates then you would just add a column for "removal" date.
Just depends on how you want to use it. Just thought I would give you an alternate version just in case.
May 22, 2024 at 08:24 AM
vcoolio, that did it. Thank you. I was not able to use the formula in the header.
-Turns out the header has a particular purpose that does not allow formula's to be added. I could create a macro that would enter the data from the formula, but I want that date to update automatically without a macro. If there's a way to do that I don't know it, and honestly don't need it. I just added a row above the top and used it. As always, thank you!