charlesstricklin
Board Regular
- Joined
- May 6, 2013
- Messages
- 88
- Office Version
- 2010
- Platform
- Windows
I'm guessing the answer to this is ridiculously simple, but I'll be danged if I can figure it out.
I want to subtract a certain number of years from the current date. For instance, as I write this the date is 2/26/2021. If I wanted to subtract 12 years from today's date I should get 2/26/2009. How do I calculate that in Excel?
Also, what if I wanted to add or subtract a certain number of months to a date. For example, if I was given the date 5/10/1960 and I wanted to subtract 6 months to have 12/10/1959 as the result?
I want to subtract a certain number of years from the current date. For instance, as I write this the date is 2/26/2021. If I wanted to subtract 12 years from today's date I should get 2/26/2009. How do I calculate that in Excel?
Also, what if I wanted to add or subtract a certain number of months to a date. For example, if I was given the date 5/10/1960 and I wanted to subtract 6 months to have 12/10/1959 as the result?