Loading ...
Sorry, an error occurred while loading the content.

2203ISO8601 Std for Day in Year?

Expand Messages
  • prmyers1
    Jul 3, 2010
    • 0 Attachment
      Has anyone come across an Excel macro (ideally compatible with all versions from Excel 2000 onwards) for formatting cells for the ISO8601 "Day in Year" format (ie "YYYYDDD" and "YYYY-DDD")? The year ("YYYY") component can be obtained using the Excel function "YEAR(cell)" but I can't find an existing Excel builtin function for the "day-in-year" ("DDD") component.

      Thanks.

      Paul Myers
      prmyers@...
    • Show all 6 messages in this topic