Forum Discussion

ilker_d's avatar
ilker_d
Copper Contributor
Jun 06, 2019

Deduct week numbers in Excel

I want to deduct week numbers in Excel but I don't know the formula (it should be something easy but I don't know)
For example in cell A1 I have 01.2019 (so this mean week 1 from 2019) and I want to have in cell B1 minus 52 week numbers from the data in A1 (so I should get 01.2018).
What should be the formula in cell B1 ? (Something like =A1-52?)

 

I hope that someone can help me with this

 

Thanks in advance

 

Regards, Ilker

developer
excel
Formulas and Functions

7 Replies

  • Elias2000's avatar
    Elias2000
    Copper Contributor
    Jun 06, 2019

    I think in the first place knowing the networking days by inserting the formula =Networking days(Start date,end date) after that it is easy to know the week day

    • ilker_d's avatar
      ilker_d
      Copper Contributor
      Jun 06, 2019

      Elias2000 

      When I use your formula I do get the month and 00 (I don't know what this is) So I guess the formula needs to be different

    • ilker_d's avatar
      ilker_d
      Copper Contributor
      Jun 06, 2019

      Twifoo

      When I use that formale I get 28-11-1931:

       

       

      Am I doing something wrong?

      • Twifoo's avatar
        Twifoo
        Silver Contributor
        Jun 06, 2019
        You must enter 1/1/2019 in A1 and format it as "mm.yyyy" so that the formula returns 1/2/2018. If you want it to return 1/1/2018, you may use this formula instead:
        =EDATE(A1,-12)

Resources