hi
Me again new question --- how do you auto format dates in Excel.
At the top of my table (see my previous question) I manually write the dates
for every Monday in the year but I would like to do this automatically any
ideas?
Also how can I change the dates every six months without having to start a
new table
Gazmac1

can't you just put the date for the first Monday in a cell and then
=thatcell+7

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"gazmac1" <(E-Mail Removed)> wrote in message
news:69C8B309-9891-490C-A9A0-(E-Mail Removed)...
> hi
> Me again new question --- how do you auto format dates in Excel.
> At the top of my table (see my previous question) I manually write the
> dates
> for every Monday in the year but I would like to do this automatically any
> ideas?
> Also how can I change the dates every six months without having to start a
> new table
> Gazmac1

sorry Don but me being completely new to Excel I need you to explain what you
mean.
(I did try but got errors)
Gazmac1

"Don Guillett" wrote:

> can't you just put the date for the first Monday in a cell and then
> =thatcell+7
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "gazmac1" <(E-Mail Removed)> wrote in message
> news:69C8B309-9891-490C-A9A0-(E-Mail Removed)...
> > hi
> > Me again new question --- how do you auto format dates in Excel.
> > At the top of my table (see my previous question) I manually write the
> > dates
> > for every Monday in the year but I would like to do this automatically any
> > ideas?
> > Also how can I change the dates every six months without having to start a
> > new table
> > Gazmac1
>
>
>

in cell a1 put in a valid date that is a Monday.
in cell b1 put in the formula
=a1+7
goto the lower right corner of that cell>find the little square>drag to the
right as many cells as desired

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"gazmac1" <(E-Mail Removed)> wrote in message
news:2D456F82-9043-4DEF-9DAF-(E-Mail Removed)...
> sorry Don but me being completely new to Excel I need you to explain what
> you
> mean.
> (I did try but got errors)
> Gazmac1
>
> "Don Guillett" wrote:
>
>> can't you just put the date for the first Monday in a cell and then
>> =thatcell+7
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "gazmac1" <(E-Mail Removed)> wrote in message
>> news:69C8B309-9891-490C-A9A0-(E-Mail Removed)...
>> > hi
>> > Me again new question --- how do you auto format dates in Excel.
>> > At the top of my table (see my previous question) I manually write the
>> > dates
>> > for every Monday in the year but I would like to do this automatically
>> > any
>> > ideas?
>> > Also how can I change the dates every six months without having to
>> > start a
>> > new table
>> > Gazmac1
>>
>>
>>

Thanks Don It worked a treat ---- easy when you know how.
Thanks again
Gazmac1

"Don Guillett" wrote:

> in cell a1 put in a valid date that is a Monday.
> in cell b1 put in the formula
> =a1+7
> goto the lower right corner of that cell>find the little square>drag to the
> right as many cells as desired
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "gazmac1" <(E-Mail Removed)> wrote in message
> news:2D456F82-9043-4DEF-9DAF-(E-Mail Removed)...
> > sorry Don but me being completely new to Excel I need you to explain what
> > you
> > mean.
> > (I did try but got errors)
> > Gazmac1
> >
> > "Don Guillett" wrote:
> >
> >> can't you just put the date for the first Monday in a cell and then
> >> =thatcell+7
> >>
> >> --
> >> Don Guillett
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "gazmac1" <(E-Mail Removed)> wrote in message
> >> news:69C8B309-9891-490C-A9A0-(E-Mail Removed)...
> >> > hi
> >> > Me again new question --- how do you auto format dates in Excel.
> >> > At the top of my table (see my previous question) I manually write the
> >> > dates
> >> > for every Monday in the year but I would like to do this automatically
> >> > any
> >> > ideas?
> >> > Also how can I change the dates every six months without having to
> >> > start a
> >> > new table
> >> > Gazmac1
> >>
> >>
> >>
>
>
>

glad to help

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"gazmac1" <(E-Mail Removed)> wrote in message
news:0D411315-5BC3-4C54-94C7-(E-Mail Removed)...
> Thanks Don It worked a treat ---- easy when you know how.
> Thanks again
> Gazmac1
>
> "Don Guillett" wrote:
>
>> in cell a1 put in a valid date that is a Monday.
>> in cell b1 put in the formula
>> =a1+7
>> goto the lower right corner of that cell>find the little square>drag to
>> the
>> right as many cells as desired
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "gazmac1" <(E-Mail Removed)> wrote in message
>> news:2D456F82-9043-4DEF-9DAF-(E-Mail Removed)...
>> > sorry Don but me being completely new to Excel I need you to explain
>> > what
>> > you
>> > mean.
>> > (I did try but got errors)
>> > Gazmac1
>> >
>> > "Don Guillett" wrote:
>> >
>> >> can't you just put the date for the first Monday in a cell and then
>> >> =thatcell+7
>> >>
>> >> --
>> >> Don Guillett
>> >> SalesAid Software
>> >> (E-Mail Removed)
>> >> "gazmac1" <(E-Mail Removed)> wrote in message
>> >> news:69C8B309-9891-490C-A9A0-(E-Mail Removed)...
>> >> > hi
>> >> > Me again new question --- how do you auto format dates in Excel.
>> >> > At the top of my table (see my previous question) I manually write
>> >> > the
>> >> > dates
>> >> > for every Monday in the year but I would like to do this
>> >> > automatically
>> >> > any
>> >> > ideas?
>> >> > Also how can I change the dates every six months without having to
>> >> > start a
>> >> > new table
>> >> > Gazmac1
>> >>
>> >>
>> >>
>>
>>
>>