Home/ Questions/Q 2438
Next
In Process
Computing Staff
  • 0
Asked: 2021-10-28T06:27:23+00:00 In:

Trying To Represent A Date As Yyyy-Ww

  • 0

need a formula to represent a date value as year nad week. Week must begin on Friday and include leading zeros.
i.e. 01/03/2014 represented as 2014-01

Share

    1 Answer

    1. Didn’t come up with my own formula,
      but see this thread, looks like it is what you need:

      http://www.mrexcel.com/forum/excel-…

      MIKE

      http://www.skeptic.com/

      • 0