D
Darlene
How can I calculate the number of weeks between two dates in different years?
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
SteveG
Darlene,
If your start date is in A1 and the end date in B1 then you could use
=(B1-A1)/7
HTH
Stev
If your start date is in A1 and the end date in B1 then you could use
=(B1-A1)/7
HTH
Stev
T
Toppers
try:
=int(b1-a1)/7) where A1, B1 are start/finish dates
HTH
=int(b1-a1)/7) where A1, B1 are start/finish dates
HTH
P
Paul Lautman
Darlene said:How can I calculate the number of weeks between two dates in
different years? Thanks
INT((date1-date2)/7)
S
SiC
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
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