View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Calculating Dates

Gaza wrote:
I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08



Have you tried anything yet? Try looking at "Add dates" in the help file.