OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to add "x" months to a date field?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
frontman
General User
General User


Joined: 13 Jan 2006
Posts: 8

PostPosted: Fri Jan 13, 2006 11:13 am    Post subject: How to add "x" months to a date field? Reply with quote

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
View user's profile Send private message
billyboy
Super User
Super User


Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland

PostPosted: Fri Jan 13, 2006 11:26 am    Post subject: Reply with quote

Have you tried Edit... Fill... Series?
Bill
_________________
OOo-DEV 3.4 -Seamonkey, Firefox & Thunderbird trunk - Win Vista HB
==============================================
Creation
Answers
Back to top
View user's profile Send private message
frontman
General User
General User


Joined: 13 Jan 2006
Posts: 8

PostPosted: Fri Jan 13, 2006 11:38 am    Post subject: Series...? Reply with quote

...

Last edited by frontman on Fri Jan 13, 2006 11:59 am; edited 2 times in total
Back to top
View user's profile Send private message
frontman
General User
General User


Joined: 13 Jan 2006
Posts: 8

PostPosted: Fri Jan 13, 2006 11:53 am    Post subject: About series Reply with quote

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
View user's profile Send private message
billyboy
Super User
Super User


Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland

PostPosted: Fri Jan 13, 2006 12:31 pm    Post subject: Reply with quote

Hi
I misunderstood. Rolling Eyes

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
View user's profile Send private message
frontman
General User
General User


Joined: 13 Jan 2006
Posts: 8

PostPosted: Fri Jan 13, 2006 1:18 pm    Post subject: PERFECT Reply with quote

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
View user's profile Send private message
frontman
General User
General User


Joined: 13 Jan 2006
Posts: 8

PostPosted: Sat Jan 14, 2006 10:55 am    Post subject: Ding, ding, ding. We got a winner. Reply with quote

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
View user's profile Send private message
billyboy
Super User
Super User


Joined: 08 Sep 2005
Posts: 504
Location: Belfast, Northern Ireland

PostPosted: Sat Jan 14, 2006 11:43 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group