Is there an easy way I can work out the number of full weeks beween 27 Sept
2008 and today?

Many thanks

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

"Sarah (OGI)" wrote in message
...
Is there an easy way I can work out the number of full weeks beween 27
Sept
2008 and today?

Many thanks

take days, divide by seven and drop the remainder.

Sarah (OGI) wrote:

Is there an easy way I can work out the number of full weeks beween 27 Sept
2008 and today?

Many thanks

On Tue, 28 Oct 2008 10:46:16 -0700, Sarah (OGI)
wrote:

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

=(TODAY()-A2)/7


where A2 holds the date

--


Regards,


Peo Sjoblom

"Sarah (OGI)" wrote in message
...
Is there an easy way I can work out the number of full weeks beween 27
Sept
2008 and today?

Many thanks

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),CntS eq))=5))
=7