Work out number of weeks

  • Thread starter Thread starter Sarah (OGI)
  • Start date Start date
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the week of date 4
Formula required for elapsed days for fund estimation 1
How do i Calculate minutes between two different dates 5
Auto calculate day of week to week of the year (not as serial) 4
Conditional Format (Todays Date) 2
Current year and current week number 9
Calculating a week between a range of dates 3
custom date format 2

Back
Top