View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Bi-weekly date calculation

On Wed, 7 Jan 2004 09:51:42 -0600, rocketslinger
wrote:

How can I programmatically calculate each bi-weekly occurrance in a
worksheet based on a start date of lets say...01/09/2004 for the whole
year?


---
Message posted from http://www.ExcelForum.com/


A1: 01/09/2004
A2: =A1+14

Copy/drag down as needed


--ron