@jasonicajin Most likely you entered the first date as text. Probable something like "1/1/2022". when you then drag the fill handle down, Excel will indeed increment the number at the end. Thus, the years.
Dates are in fact numbers, starting at 1 for 1 January 1900. Check the real nature of your "dates" using the ISNUMBER (a date will return TRUE) or ISTEXT (a data will return FALSE) function. Or just change the cell format to General. If it's a data you'll see a number in the 44562-44926 range for dates in 2022. If it's text, nothing will happen.
