View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Calculating Dates

If A1 = Start date

B1=A1+7

and format B1 to Date

If this post helps click Yes
---------------
Jacob Skaria


"brewster56" wrote:

I would like to have Excel add 7 days to a starting date and display that in
a Date format. What I am doing is scheduling something every week on the
same day and didn't want to constantly go to the calendar and look up the
following weeks date.

Is this even possible ?