Quote:
Originally Posted by gts055
Thanks again, Mark
|
No worries Mark, the version I posted should work for MS Excel 97 and onwards.
Here is another one where the static Year should update automatically, based on the system date of your operating system, although it will only work in Excel 2010 (and hopefully onwards

).
I guess I’ll find out on 1st Jan 2016 as I haven’t tested it yet!
Cheers
Dennis