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
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

Resources