#VALUE! ERROR ASSISTANCE

[meppwc]

I keep getting the value error when I put in the formula = INT(YEARFRAC(A1, A2)), or =YEARFRAC(A1,B1)
I have A1 and B1 formatted as dates. And I have tried formatting C1 (has the formula), as general, text and number and still get the value error

07/27/1895

10/27/1966​

#VALUE!​

 

[Joe4]

I believe that Excel does not like performing calculations on dates prior to 1900.

See here for potential workarounds: How to Work with Dates Before 1900 in Excel - ExcelUser.com.

 

[I_know_nuffin]

could have something to do with this

YEAR(serial_number) returns a year corresponding to a given date, as a number from 1900 to 9999.