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...
developer
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Jun 06, 2019
Your formula could be:
=A1-7*52
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)
    • ilker_d's avatar
      ilker_d
      Copper Contributor
      Jun 06, 2019

      Twifoo 

       

      Yes but now I get the month and year, but I need to see the week and year :(

Resources