Thread: Calculate every Monday
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Calculate every Monday
Hi

You could put 01/01/2007 (which is a monday) in A1.
In A2 put =A1+7 and drag the formula down 53 rows.

HTH
Martin


Reply With QuoteReply With Quote