How to Calculate Number of Weeks In excel refering to todays date in my System date.

I want to calculate Number of Weeks from Today in a Excel sheet. ex 13/07/2013 How many Weeks passed referring to today's date. Dose anyone know a formula or something for this?

this is my date format in excel sheet and i have the same format in my system date. Please help

July 16th, 2013 11:06pm

If your "13/07/2013" is in A1, then put this in B1:

=ROUNDDOWN((TODAY()-A1)/7,0)

Doesn't that get you the number of weeks between today and the date in question?

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2013 11:21pm
it is not working mate. I am running Windows Xp and my windows date format is mm/dd/yyyy in excel also its same . but cant get it. is there any other ways of getting this thing done?
July 17th, 2013 5:19am
The date format shouldn't matter. Is the formula above throwing an error, or just not producing the value you want?
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2013 7:58am

Hi,

I agree with Jerry's formula, I think is should work.

What's issue now for the formula?

July 18th, 2013 1:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
13/07/2013
07/03/2013
07/09/2013
07/03/2013