editing date fields in word 2000 or ms-excel

mrtigress · 10-02-2005, 04:55 PM

Hello;
I have been working on a project for weeks now and have not been able to produce the results that I am looking for. I was told that I could use excel or msword for this document the user needs.
The document contains fields that hold a date spread (mmmyy) for a 1 year (JUN 06 JUL 06 AUG 06, etc). The user is to place the begining date in the first cell and the application should process the next 11 dates in sucession.
(ex: I enter Jun06, On the document,
JUn06 JUL 06 AUG 06 sep 06 oct 06 nov 06 dec 06 jan 08 feb 08 mar 08 apr 08 may 08). As you see that the user doesn't have to start as JAN 06. The year field has to change also when crossing over into the next year. The problem that I am having in word or Excel is there seems to be no function or formula that would allow me the flexability to modify these individual fields. I am open to use any application availiable on the market but would prefer to stay with ms_word or ms_excel. Thank you ahead of time.
Don Rago

charly · 10-12-2005, 03:22 PM

well, a better english would help (to translate) more BUT:

excel does whatever you want
if you click on HELP you'll get the needet functions like
weekday(mmddyy), still you can set a column as date field
like A1 = date
a2 = $A1 + 1
excel will add 1 day
still you can get with excel sundays, or weekdays (MO-FR or MO - SA)

i've done a macro what gets day's and date till 2099 using regular excel functions so i should work for you 2.
ciao

10-02-2005, 04:55 PM	#1 (permalink)
mrtigress New Member Join Date: Sep 2005 Posts: 9	editing date fields in word 2000 or ms-excel Hello; I have been working on a project for weeks now and have not been able to produce the results that I am looking for. I was told that I could use excel or msword for this document the user needs. The document contains fields that hold a date spread (mmmyy) for a 1 year (JUN 06 JUL 06 AUG 06, etc). The user is to place the begining date in the first cell and the application should process the next 11 dates in sucession. (ex: I enter Jun06, On the document, JUn06 JUL 06 AUG 06 sep 06 oct 06 nov 06 dec 06 jan 08 feb 08 mar 08 apr 08 may 08). As you see that the user doesn't have to start as JAN 06. The year field has to change also when crossing over into the next year. The problem that I am having in word or Excel is there seems to be no function or formula that would allow me the flexability to modify these individual fields. I am open to use any application availiable on the market but would prefer to stay with ms_word or ms_excel. Thank you ahead of time. Don Rago

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

10-12-2005, 03:22 PM	#2 (permalink)
charly Silver Member Join Date: Dec 2003 Location: austria Age: 47 Posts: 158	well, a better english would help (to translate) more BUT: excel does whatever you want if you click on HELP you'll get the needet functions like weekday(mmddyy), still you can set a column as date field like A1 = date a2 = $A1 + 1 excel will add 1 day still you can get with excel sundays, or weekdays (MO-FR or MO - SA) i've done a macro what gets day's and date till 2099 using regular excel functions so i should work for you 2. ciao