View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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