Thread: Calculate every Monday
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Calculate every Monday
to calculate the first one from 1/1/2006 in cell b1. Then +7 for others.
=B1-DAY(B1)+8-WEEKDAY(B1-DAY(B1)+6)

--
Don Guillett
SalesAid Software

"Wanna Learn" wrote in message
...
Hello How do I calculate the date for every Monday in the year 2007?
thanks


Reply With QuoteReply With Quote