Thread
:
Working out the date
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Working out the date
look here
http://www.cpearson.com/excel/weeknum.htm
--
Don Guillett
SalesAid Software
"Spiller" wrote in message
...
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
Reply With Quote