Thread: Work out number of weeks
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default 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


Reply With QuoteReply With Quote