S
Sarah (OGI)
Is there an easy way I can work out the number of full weeks beween 27 Sept
2008 and today?
Many thanks
2008 and today?
Many 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.
H
Harald Staff
Depending on how you define full weeks (and define "between"). If it's
multiples of 7 days then
=INT((TODAY()-DATE(2008,9,27))/7)
HTH. Best wishes Harald
multiples of 7 days then
=INT((TODAY()-DATE(2008,9,27))/7)
HTH. Best wishes Harald
B
Bob I
take days, divide by seven and drop the remainder.
R
Ron Rosenfeld
Is there an easy way I can work out the number of full weeks beween 27 Sept
2008 and today?
Many thanks
=INT((TODAY()-DATE(2008,9,27))/7)
--ron
P
Peo Sjoblom
=(TODAY()-A2)/7
where A2 holds the date
--
Regards,
Peo Sjoblom
where A2 holds the date
--
Regards,
Peo Sjoblom
H
Herbert Seidenberg
Excel 2007
Start
9/4/2008
End
10/28/2008
DRange
=ROW(INDEX($A:$A,Start):INDEX($A:$A,End))
WwSeq
=IF(WEEKDAY(DRange,2)>5,0,1)
CntSeq
=ROW(INDEX($A:$A,1):INDEX($A:$A,COUNTA(DRange)))
Count of whole work weeks (Monday-Friday)
Enter with Ctrl+Shift+Enter:
=SUMPRODUCT(--
(FREQUENCY(IF(WwSeq=1,CntSeq),IF(NOT(WwSeq=1),CntSeq))=5))
=7
Start
9/4/2008
End
10/28/2008
DRange
=ROW(INDEX($A:$A,Start):INDEX($A:$A,End))
WwSeq
=IF(WEEKDAY(DRange,2)>5,0,1)
CntSeq
=ROW(INDEX($A:$A,1):INDEX($A:$A,COUNTA(DRange)))
Count of whole work weeks (Monday-Friday)
Enter with Ctrl+Shift+Enter:
=SUMPRODUCT(--
(FREQUENCY(IF(WwSeq=1,CntSeq),IF(NOT(WwSeq=1),CntSeq))=5))
=7