View Single Post
  #10  
Old 25-05-2015, 09:24 AM
Dennis
Dazzled by the Cosmos.

Dennis is offline
 
Join Date: May 2005
Location: Brisbane
Posts: 11,820
Quote:
Originally Posted by gts055 View Post
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
Attached Files
File Type: zip Tak Date Time Converter 2015 Auto Year Calc.zip (30.7 KB, 18 views)
Reply With Quote