Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between dates in Excel 2000
How can I calculate the number of weeks between two dates in different years?
Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between dates in Excel 2000
Darlene, If your start date is in A1 and the end date in B1 then you could use =(B1-A1)/7 HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=547218 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between dates in Excel 2000
try:
=int(b1-a1)/7) where A1, B1 are start/finish dates HTH "Darlene" wrote: How can I calculate the number of weeks between two dates in different years? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between dates in Excel 2000
Darlene wrote:
How can I calculate the number of weeks between two dates in different years? Thanks INT((date1-date2)/7) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate number of weeks between dates in Excel 2000
Hi Darlene,
Basically it's just =(date2-date1)/7 where date2 and date1 are cell references for your two dates. =ROUND((date2-date1)/7,0) if you want to round to the nearest whole week =CEILING((date2-date1)/7,1) if you want to always round up to the nearest whole week =FLOOR((date2-date1)/7,1) if you want to always round down to the nearest whole week Hope this helps. -Simon "Darlene" wrote: How can I calculate the number of weeks between two dates in different years? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Calculate number of months between 2 dates | New Users to Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |