Simple date subtraction excel
SolvedMasonFoster Posts 1 Registration date Wednesday September 25, 2024 Status Member Last seen October 7, 2024 - Oct 7, 2024 at 05:52 AM
- Simple date subtraction excel
- Excel date format dd.mm.yyyy - Guide
- Excel marksheet - Guide
- Excel apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
5 responses
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.
May 23, 2024 at 01:20 AM
You're welcome Sean. I'm glad to have been able to assist again.
Cheerio,
vcoolio.
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.
Aug 23, 2024 at 08:16 AM
Calculate the difference in days
- Select cell D2, which is the first blank cell in the Duration column.
- Type =C2-B2, and then press RETURN . Excel displays the result as the number of days between the two dates (104).
- Select cell D2.
- To copy the formula into the remaining rows, drag the fill handle .
Didn't find the answer you are looking for?
Ask a questionOct 7, 2024 at 05:52 AM
Thank you so much for the information.
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!