hello and welcome to this video tutorial

from computer Garga comm and in this

video we are going to look at how to

calculate the week number of a given

date so this was something I was asked

recently and I found interesting enough

to produce a video for and it may be

useful if you're involved in projects

and you've got task lists like a heaven

screen and you want to know what is the

week number of that project so you need

to be able to start it from any date not

just the 1st of January in a start in

the year but whenever that project

started it can also be useful to count

down to a specific due date like the

birth date of a child and you want to

know like how many weeks until that due

date whatever it may be so it has

multiple uses Excel in fact have a

function called week num that does a

similar job it returns the week number

of the year so it's not exactly what I

want to demonstrate in this video

because I want the week number from any

given start date whereas that one just

uses the 1st of January the start of the

year so we're going to create our own

customized version of week num really so

let's have a look we've got these

examples from screen now the very first

one let's imagine that is the start day

of this entire project this process

whatever it is so I'm just going to type

1 for that no formula needed that's the

first one but then for any other given

dates we can type equals and then I'm

going to select the date of that row so

21st of October be free as it would be

and I'm going to subtract the date the

start date so here it's b2 but that

would be whatever cell contains that

start date and I'm going to make that an

ABS

reference because soon I'm going to drag

and copy this formula down to the other

cells the other dates and I want this to

move into 28 October 30th October 2nd

November but that needs to stay on that

start date I'm then going to divide that

by 7 now 7 indicating 7 days a week

because I'm doing a subtraction and a

divide in one formula I will need

parentheses or brackets around the

subtraction part I wanted to subtract

the start date from the current date and

then divide the answer by 7 so that I

get weeks not days and I am then going

to +1 on the end because we've already

got our first week number the answer to

that would be 1 so I'm going to add 1 on

top so I get 2 it was one after that

calculation so if I press ENTER it tells

me that's week two and as you can

probably see that is exactly seven days

after I believe these are both Sundays I

think if I remember what I wrote if I

drag that down it now does it for all of

them so another 7 days later we have

week free but notice this next date is

still in that third week then we have a

date in the fourth week another date in

the fourth week then a day in the fifth

week so we are calculating the week

number from any given date and from any

given start date here it's the 14th

October quite a random date but we can

input whatever we would like and as I

mentioned at the start of this video you

can flip that on its head and work is a

kind of countdown to a date

how many weeks until as opposed to how

many weeks kind of from which I'm

demonstrating here now one other little

thing to add to this you know that's

wonderful that may be all you need but

it's look at a little bit of custom

formatting just to go that extra mile if

I highlight those

and go into my format sales window and

choose custom I would like to set up a

custom format for those cells so rather

than just showing the number I want it

to say the word week as well so in this

type field

I might select the zero so it puts a

number in saves me that massive amount

of typing but then before that zero I'm

going to open up some double inverted

commas write the word week spaced close

in double inverted commas and then we

have that number

so if I click OK this is what we get I

now have the word week preceding that

number but it's just formatting you

notice if I click on cell c2 that in the

formula bar it still just says number

one you know the week is not in that

cell it is formatted to appear in that

cell

so you may not decide to have the word

week in cell you may wish to format it

otherwise or just be happy happy with

that number but I thought it would be a

nice little demonstration on top of our

formula calculation I hope you found

this video useful please check out some

of our other video tutorials on our

YouTube channel and come check us out at

computer Gaga com

you