| 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. |
| 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 | |||
Threaded Mode
