Quote:
Originally Posted by CubbyFan23
This is going to sound like a dumb question but oh well. 
I've noticed for the birthdates, a LARGE number are off by just one year. By large I mean 85-90%. So I think if we can fix that, it won't be as big of an issue for the first release and we can touch them up later.
Does anyone know how to increase an entire column (which lists birthdates by xx/xx/xxxx format) by one year in Excel? I can export the rosters, open them in Excel, do this, and reimport to change everyone by a year, but I'm unsure how to do this. |
Assuming the value is in cell A1. Formula to change
=DATE(YEAR(A1)+1, MONTH(A1), DAY(A1))
Would need to put that in another column