A
Arvi Laanemets
Hi
C2=DATEDIF(A2,B2,"y")
etc.
C2=DATEDIF(A2,B2,"y")
etc.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Crni Zeko
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?
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?
A
Alex Delamain
If you just want the difference in the year then in C1
=year(b1)-year(a1
=year(b1)-year(a1
F
Fedor Shihantsov
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))
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))
C
Crni Zeko
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?
i did what you suggested but some results are inncorecct
for example
=year(23.12.94)-year(14.7.24)
=-30.00
how come?