Answered by:
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
13/07/2013 07/03/2013 07/09/2013 07/03/2013
prabhath
Question
Answers

In your first post you stated your Windows and Excel formats were the same, and you gave an example of 13/07/2013 as a date (which would imply a date format of dd/mm/yyyy)
In this response you indicate your date format is mm/dd/yyyy for both windows and excel.
That being the case, the "13/07/2013" date is probably a text string, and not a "real date".
The formula will work when applied to Excel Dates (the format does not matter). The formula will not work when applied to text strings.
Onceyou get your data straightened out, so that all of the dates are true Excel dates, the formula will work.
If, in fact, your dates are all true dates, and not a mixture of text strings and dates, then there is some other problem with your workbook as there is no reason why that formula should not work.
So please post back exactly what you mean by "It's not working mate"
 error message: if so what is the error
 incorrect results: if so, what is the original data, desired result, and actual result
 Excel crash: any error messasge?
 Other: be descriptive
One other possibility: Ensure the cell containing your formula is formatted as General.
 Edited by Ron Rosenfeld Thursday, July 18, 2013 11:11 AM add'l info
 Marked as answer by Jaynet ZhangMicrosoft contingent staff, Moderator Tuesday, July 23, 2013 9:10 AM
All replies





In your first post you stated your Windows and Excel formats were the same, and you gave an example of 13/07/2013 as a date (which would imply a date format of dd/mm/yyyy)
In this response you indicate your date format is mm/dd/yyyy for both windows and excel.
That being the case, the "13/07/2013" date is probably a text string, and not a "real date".
The formula will work when applied to Excel Dates (the format does not matter). The formula will not work when applied to text strings.
Onceyou get your data straightened out, so that all of the dates are true Excel dates, the formula will work.
If, in fact, your dates are all true dates, and not a mixture of text strings and dates, then there is some other problem with your workbook as there is no reason why that formula should not work.
So please post back exactly what you mean by "It's not working mate"
 error message: if so what is the error
 incorrect results: if so, what is the original data, desired result, and actual result
 Excel crash: any error messasge?
 Other: be descriptive
One other possibility: Ensure the cell containing your formula is formatted as General.
 Edited by Ron Rosenfeld Thursday, July 18, 2013 11:11 AM add'l info
 Marked as answer by Jaynet ZhangMicrosoft contingent staff, Moderator Tuesday, July 23, 2013 9:10 AM