Forum Discussion
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...
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.