Calculate Dates

N

NINA

Source Data coming in this format 19880716 would like to calculate the
difference in years between the source data date and the date 01/01/2010. How
would I write this formula. Appreciate anyone help--
NINA
 
B

Bob Phillips

Either

=2010-LEFT(A1,4)

or

=2010-LEFT(A1,4)-1

depending on whether a part year counts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount -Date Criteria - Won´t find it - 0
Display weeks from a Milestone 0
Upgraded to Onenote 2016 but all data is old 0
Specific Date from a Range 3
How to count non blank cells with a condition? 1
Summary of Difference between dates in years, months, days 4
Count specific days in between dates 2
calculate 6 months forward from a date 8

Top