Tuesday, December 6, 2016

An utility (Excel) to deal with dates from my execs

SMF data often gives dates in format of YYYY.nnn ,  (For example 2016.307 , corresponding to 02/11/2016), I am in general a bit lazy to transform this in my rexx ...
I use this Excel in my daily work to switch between "normal date" format and this YYYY.nnn format (there is a name for this, but no place in my litle brain to remember)

Here is the link to my Excel to do this :

 https://www.evernote.com/shard/s381/sh/cc820363-7867-4292-bba1-30f45b541ed7/a63aa3cdea70a145badf6b39d254896f

No comments:

Post a Comment