Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates Formating
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates Formating
can't you just put the date for the first Monday in a cell and then
=thatcell+7 -- Don Guillett SalesAid Software "gazmac1" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates Formating
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 "gazmac1" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates Formating
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 cellfind the little squaredrag to the right as many cells as desired -- Don Guillett SalesAid Software "gazmac1" wrote in message ... 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 "gazmac1" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates Formating
glad to help
-- Don Guillett SalesAid Software "gazmac1" wrote in message ... 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 cellfind the little squaredrag to the right as many cells as desired -- Don Guillett SalesAid Software "gazmac1" wrote in message ... 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 "gazmac1" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating dates | New Users to Excel | |||
conditional formating dates | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
conditional formating: dates | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |