question

  • Thread starter Thread starter Arvi Laanemets
  • Start date Start date
Hello
I have a question any help would be appreciated.
In column A I have around 1500 dates and in column B also,and I want to make
column C that will have differences in years for every row.How can i do
that?
 
If you just want the difference in the year then in C1


=year(b1)-year(a1
 
Hi!

Use the function YEAR
E.g. formula in C column can look like this:
=IF(YEAR(A1)<>YEAR(B1);"different";"the same")
or
=IF(YEAR(A1)>=YEAR(B1);YEAR(A1)-YEAR(B1);YEAR(B1)-YEAR(A1))
 
thanks
i did what you suggested but some results are inncorecct
for example
=year(23.12.94)-year(14.7.24)

=-30.00

how come?
 
You must log in or register to reply here.

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

Excel DateDif - why does 2007 seem different? 3
Calculating time between mulitple dates 4
adjust formula to much info 1
A mathematical formula question??? 3
Calculating elapsed days and hours 4
Datedif gives wrong result 1
changed DOB to age, but if no DOB need cell to be empty. 4
Modified ACOS function 2

Back
Top