Hi and welcome to the forum

Just a quick note...if you are getting your data from an external source, the values (dates and numbers) may actually be text that just looks like a number - you need to check for that 1st by using =isnumber() on some of the cells in a row...FALSE indicated text