How can I calculate the number of weeks between two dates in different years?
Thanks

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

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

Darlene wrote:
How can I calculate the number of weeks between two dates in
different years? Thanks

INT((date1-date2)/7)

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