Work out number of weeks
 

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

Many thanks

Work out number of weeks
 

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

Work out number of weeks
 

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

Work out number of weeks
 

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

Work out number of weeks
 

=(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

Work out number of weeks
 

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