Thread: Work out number of weeks
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default 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
Reply With QuoteReply With Quote