你即將離開本站

並前往https://www.mrexcel.com/board/threads/week-number-and-year-from-date.1149578/

Week Number and Year from Date

One way is. Excel Formula: =TEXT(WEEKNUM(AH2,21),"00")&TEXT(AH2, "-yyyy")-(AND(MONTH(AH2)=12,WEEKNUM(AH2,21)=1)).

確定！ 回上一頁

查詢 「Number to text Excel」的人也找了：

  1. Excel number to text formula
    2.
  2. Excel number to English text
    3.
  3. Excel number stored as text
    4.
  4. excel text轉文字
    5.
  5. The number in this cell is formatted as text or preceded by an apostrophe
    6.
  6. excel text + text formula
    7.
  7. excel text用法
    8.
  8. Excel VBA number to text
    9.