| View previous topic :: View next topic |
| Author |
Message |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
 Posted: Thu May 17, 2012 11:14 am Post subject: |
 |
|
=DATE(YEAR(A1);MONTH(A1)+3;DAY(A1))
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
 |
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 209
|
| Posted: Thu May 17, 2012 11:15 am Post subject: |
|
|
Hi
| Quote: | | karo why doesnt the formula work for me |
How could i know this, i cannot look over your shoulders - may be your Dates are Text but not DateValues ??
@Ken
In other Words, he needs the next Date after TODAY() count in Intervalls of n months since Date in Column C.
( If this Explanation is wrong, its because i'm not a native English )
Karo |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1851
Location: Sydney, Australia
|
| Posted: Fri May 18, 2012 6:28 am Post subject: |
|
|
I also could not get Karo's formula to work.
There is definitely a problem with the formula, the dates I'm using are not text. Also, the MONTH function accepts only one parameter, not three.
Try this array formula in D2...
| Code: | | MIN(IF(EDATE(C2;ROW($A$1:$A$400)*B2)<TODAY();"";EDATE(C2;ROW($A$1:$A$400)*B2))) |
Array formulae must be entered using Ctrl+Shift+Enter.
Also, when you use the fill handle to get array formulae into adjacent cells (D3:D5) you must hold down the Ctrl key while dragging the fill handle.
See attached doc...
http://www.mediafire.com/view/?oiiyuorsg56row9
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
