software

Somebody please help me as this is driving me insane!
What i would like excel to do is automatically input the date that is 6
weeks after the date i input!
For example, in column 1 i put the date 01/01/2006, in column 2 i would like
the date 6 weeks after that to automatically appear, which would be 12/02/2006

Is this type of thing possible to do on excel? And if it it will the
computer undertsand weeks or will it have to be in days (so 6 weeks would be
42 days).

I hope someone can shed some light on this for me. If you need any further
clairification then please ask.

Thank you

look here
www.cpearson.com/excel/weeknum.htm

--
Don Guillett
SalesAid Software

quot;Spillerquot; gt; wrote in message
...
gt; Somebody please help me as this is driving me insane!
gt; What i would like excel to do is automatically input the date that is 6
gt; weeks after the date i input!
gt; For example, in column 1 i put the date 01/01/2006, in column 2 i would
gt; like
gt; the date 6 weeks after that to automatically appear, which would be
gt; 12/02/2006
gt;
gt; Is this type of thing possible to do on excel? And if it it will the
gt; computer undertsand weeks or will it have to be in days (so 6 weeks would
gt; be
gt; 42 days).
gt;
gt; I hope someone can shed some light on this for me. If you need any further
gt; clairification then please ask.
gt;
gt; Thank you
If you put your date in A1, enter this formula in B1:

=IF(A1=quot;quot;,quot;quot;,A1 42)

Format this cell as a date in the way you wish and copy down the column
- if you haven't entered a date in column A then the column B will be
blank.

Hope this helps.

Peteyou could try
1/01/2006 12/02/2006

both cells formatted to date, date typed into first cell , formula in second
cell =
=A1 42
and your done.

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
quot;Spillerquot; gt; wrote in message
...
gt; Somebody please help me as this is driving me insane!
gt; What i would like excel to do is automatically input the date that is 6
gt; weeks after the date i input!
gt; For example, in column 1 i put the date 01/01/2006, in column 2 i would
gt; like
gt; the date 6 weeks after that to automatically appear, which would be
gt; 12/02/2006
gt;
gt; Is this type of thing possible to do on excel? And if it it will the
gt; computer undertsand weeks or will it have to be in days (so 6 weeks would
gt; be
gt; 42 days).
gt;
gt; I hope someone can shed some light on this for me. If you need any further
gt; clairification then please ask.
gt;
gt; Thank you
Thank you so much Pete! My headache has now disappeared!!!

quot;Pete_UKquot; wrote:

gt; If you put your date in A1, enter this formula in B1:
gt;
gt; =IF(A1=quot;quot;,quot;quot;,A1 42)
gt;
gt; Format this cell as a date in the way you wish and copy down the column
gt; - if you haven't entered a date in column A then the column B will be
gt; blank.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

Thanks for the feedback. Glad to hear you are feeling better!

Pete