| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between two cells
How do I calculate the number of weeks between two cells?
Example B2 = 1/1/08 B3 = 5/10/09 B4 = Formula for # of weeks between B2 and B3 Any assistance would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate number of weeks between two cells
One interpretation:
=INT((B3-B2)/7) -- Tim Zych www.higherdata.com Compare data in Excel and find differences with Workbook Compare A free, powerful, flexible Excel utility "Jane Schuster" wrote in message ... How do I calculate the number of weeks between two cells? Example B2 = 1/1/08 B3 = 5/10/09 B4 = Formula for # of weeks between B2 and B3 Any assistance would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
| Calculate number of weeks a variable spans in | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| Calculate number of weeks between dates in Excel 2000 | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . | Excel Worksheet Functions | |||
Linear Mode
