# subtracting years from current date

#### txg11516641

##### New Member
I need a formula that will take the current year, subtract 6 years, and display the resulting year.

I also need one that will take a date displayed (mm/dd/yyyy format) in cell J2, subtract 6 years, and display the resulting year.

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### barry houdini

##### MrExcel MVP
If you just want a year as a result (not a date) then try this for the current year

=YEAR(TODAY())-6

and for a date in J2 that would be

=YEAR(J2)-6

Thanks so much!

#### DavidDurham

##### New Member
Greetings, this is my first post. I am looking for something similar to this question. I am building a data base for my church that will tell us how many days, weeks, months and years since an event; such as baptism, joining the church, time between a member helping with an event etc...so far I'm doing this

C1 = date of event
D1 = current date using the NOW function

For day calculation I simply use =D1-C1
for week =(d1-C1)/52
for Month =(D1-C1)/30
for year =(D1-C1)/365

Is there an easier & more accurate formula(s)?

Replies
2
Views
33
Replies
7
Views
114
Replies
16
Views
110
Replies
2
Views
52
Replies
3
Views
56

Threads
1,108,909
Messages
5,525,581
Members
409,651
Latest member
Quasar Hunter