Forum Discussion
jasonicajin
Nov 12, 2022Copper Contributor
trouble autofilling by day
I just restarted my office subscription in an office of google sheet users because of the ease with which i can autofill years by each day and now I can't figuring out how to do it. I get the au...
Riny_van_Eekelen
Nov 12, 2022Platinum Contributor
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.