View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brewster56 brewster56 is offline
external usenet poster
 
Posts: 24
Default Calculating Dates

WOW - I would never have thought of that or thought that it could be that
simple. THANK YOU !!!!!

"Jacob Skaria" wrote:

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 ?