View Single Post
  #1   Report Post  
Squirel Eater
 
Posts: n/a
Default set a date in columns 7 days apart

How can I set a date in subsequent columns that are 7 days apart? I have
tried
=DAY(IF(B3="","",B3+7)) but if given a date March 6, 2005 it will show 31
days in April. Any suggestions?