| View previous topic :: View next topic |
| Author |
Message |
frontman
General User
Joined: 13 Jan 2006
Posts: 8
|
 Posted: Fri Jan 13, 2006 11:13 am Post subject: How to add "x" months to a date field? |
 |
|
Howdy,
I am trying to add "x" number of months to given date field.
I know that I can easily add days to a date but how do I add months?
My goal--> 1/13/2006 + 3 (months) = 4/13/2006
(I am not concerned about number of days in each month; only whole months).
THANKS!
Chris
Atlanta |
|
| Back to top |
|
 |
billyboy
Super User
Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland
|
| Posted: Fri Jan 13, 2006 11:26 am Post subject: |
|
|
Have you tried Edit... Fill... Series?
Bill
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers |
|
| Back to top |
|
|
frontman
General User
Joined: 13 Jan 2006
Posts: 8
|
| Posted: Fri Jan 13, 2006 11:38 am Post subject: Series...? |
|
|
...
Last edited by frontman on Fri Jan 13, 2006 11:59 am; edited 2 times in total |
|
| Back to top |
|
|
frontman
General User
Joined: 13 Jan 2006
Posts: 8
|
| Posted: Fri Jan 13, 2006 11:53 am Post subject: About series |
|
|
Okay Bill,
I did edit, fill, series. But I was only able to choose 'series' on a several fields at one time. This does not seem to be what I need...
Try this...
A1+A2=A3
A1 being 1/13/2006
A2 being x
A3 to be 1+x/13/2006
Does this help any? Looking to let user just put in "X" .
Thanks!
Chris |
|
| Back to top |
|
|
billyboy
Super User
Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland
|
| Posted: Fri Jan 13, 2006 12:31 pm Post subject: |
|
|
Hi
I misunderstood. 
There is a function EOMonth that takes a start date and number of months to create date of last day in month. Haven't used it but worth trying. You'll have to use subtraction to return to the correct day in the date.
Look in function list (Insert... Function List)
also
See Help eomonth
Let us know how it works?
nb there is also a function that returns the number of days in a month. = daysinmonth
Bill
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers |
|
| Back to top |
|
|
frontman
General User
Joined: 13 Jan 2006
Posts: 8
|
| Posted: Fri Jan 13, 2006 1:18 pm Post subject: PERFECT |
|
|
I took a maybe 4 cells worth of steps to get it but EXCELLENT it worked.
I would not have found it without your help.
A giant thanks!
Chris |
|
| Back to top |
|
|
frontman
General User
Joined: 13 Jan 2006
Posts: 8
|
| Posted: Sat Jan 14, 2006 10:55 am Post subject: Ding, ding, ding. We got a winner. |
|
|
EDATE
This function is only available if Analysis AddIn is installed.
The result is a date which is a number of Months away from the Start date. Only months are considered; days are not used for calculation.
Syntax
EDATE(Start date;Months)
Start date: a date.
Months: the number of months.
Example
What date is one month prior to 3.31.2001?
=EDATE("3.31.2001";-1) returns 2.28.2001. |
|
| Back to top |
|
|
billyboy
Super User
Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland
|
| Posted: Sat Jan 14, 2006 11:43 am Post subject: |
|
|
Thanks for getting back.
That is very much easier. Glad you got it solved.
Bill
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers |
|
| Back to top |
|
|
|
