Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to calculate the nuber of weeks between dates?
What would the function (if any) be to calculate the number of weeks between
two dates. Someone helped me with a function that calculates the number of days as: =DATEDIF(B2,X2,"d") I tried simply changing the "d" to "w" in hopes the d was short for days and W would be short for weeks, but it didn't work. I'm new to Excel and using Excel 2002. Is there a function that can calculate the number of weeks between two dates? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to calculate the nuber of weeks between dates?
Maybe:
=DATEDIF(B2,X2,"d")/7 ?? There doesn't appear to be a "w" option Have a look at Chip Pearson's page on the subject: http://www.cpearson.com/excel/datedif.htm Regards Trevor "Fish" wrote in message . net... What would the function (if any) be to calculate the number of weeks between two dates. Someone helped me with a function that calculates the number of days as: =DATEDIF(B2,X2,"d") I tried simply changing the "d" to "w" in hopes the d was short for days and W would be short for weeks, but it didn't work. I'm new to Excel and using Excel 2002. Is there a function that can calculate the number of weeks between two dates? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to calculate the nuber of weeks between dates?
Hi Fish
Can you not use your existing formula to calculate the number of days and then divide the result by 7? -- Regards William XL2003 "Fish" wrote in message . net... What would the function (if any) be to calculate the number of weeks between two dates. Someone helped me with a function that calculates the number of days as: =DATEDIF(B2,X2,"d") I tried simply changing the "d" to "w" in hopes the d was short for days and W would be short for weeks, but it didn't work. I'm new to Excel and using Excel 2002. Is there a function that can calculate the number of weeks between two dates? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to calculate the nuber of weeks between dates?
You don't really need DATEDIF for calculating the number of days between 2 dates =X2-B2 would suffice so for weeks =(X2-B2)/7 or if you want weeks and days in text... =INT((B1-A1)/7)&" weeks "&MOD(B1-A1,7)&" days" -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521961 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to calculate the nuber of weeks between dates?
You don't really need DATEDIF for calculating the number of days between 2 dates =X2-B2 would suffice so for weeks =(X2-B2)/7 or if you want weeks and days in text... =INT((B1-A1)/7)&" weeks "&MOD(B1-A1,7)&" days" -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521961 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
Function fails to calculate | Excel Worksheet Functions | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
calculate with dates before 1-1-1900 | Excel Worksheet Functions |