Formulas to find the suitable dates

[MisterExcellent]

Hello,

Could you help me to find the correct formulas, please?

Download: date formulas

 

[Marcelo Branco]

Shorter formula (not so ugly...)

D5
=TEXT(C5+1,"dd/mm/yyyy")&" - "&TEXT(DATE(YEAR(C5),MONTH(B5)+3*MATCH(IF(MONTH(B5)>MONTH(C5+1),MONTH(C5+1)+12,MONTH(C5+1)),CHOOSE({1,2,3,4},MONTH(B5),MONTH(B5)+3,MONTH(B5)+6,MONTH(B5)+9))-12*(DAY(B5)>DAY(C5)),DAY(B5)),"dd/mm/yyyy")

Ctrl+Shift+Enter
copy down

M.

 

[MisterExcellent]

Solved by Marcelo. Thank you very much, Marcelo

Marcelo, Marcelo, Marcelo!!!
****! You are really amazing! You are Excellent! ray:

I have posted this in 5 different Forums and got uncountable possiblities without the right solution.

I have asked so many people and sent some unpleasant personal messages ( sorry, folks! ). But, nobody has been able to construct the right formula.

Just you. And I feeled and hoped that.

Thank you very much Marcelo! Mais uma vez, agradeço.

Have a nice day and I hope to see you at the next time as a real "Regulator!"

Goodbye Marcelo

 

[Marcelo Branco]

oops...

small error in my last formula
=TEXT(C5+1,"dd/mm/yyyy")&" - "&TEXT(DATE(YEAR(C5),MONTH(B5)+3*MATCH(IF(MONTH(B5)>MONTH(C5+1),MONTH(C5+1)+12,MONTH(C5+1)),CHOOSE({1,2,3,4},MONTH(B5),MONTH(B5)+3,MONTH(B5)+6,MONTH(B5)+9))-12*(MONTH(B5)>MONTH(C5)),DAY(B5)),"dd/mm/yyyy")

Ctrl+Shift+Enter

M.

 

[Marcelo Branco]

Thank you!!!

All the best

M.

 

[p45cal]

Re: Solved by Marcelo. Thank you very much, Marcelo

I have posted this in 5 different Forums and got uncountable possiblities without the right solution.

I have asked so many people and sent some unpleasant personal messages ( sorry, folks! ). But, nobody has been able to construct the right formula.

Now you tell us!

Please, if you haven't already done so, out of courtesy to those on those other forums trying to help you, tell them that you've found a solution here.

It would have been nice if you had told us that you had cross-posted this question elsewhere, so that we could check at those other places whether you already had a solution - this would save us from working for you (for free and needlessly) when you already have a solution from elsewhere.

Tell me, if you find someone has been inconsiderate to you, do you feel inclined to be considerate to them? It could be in your own best interests (if you must cross-post at all) to tell people where you have cross-posted to.

I, for one, am small-minded enough when I discover such a poster to make a mental note not to answer their posts - after all, I'd probably be just duplicating what someone else has done elsewhere and I can't check.

Would you do any different?

see point 2 in the 3rd sticky on this forum:
Sticky: Guidelines for posting (updated 22 Nov 2006)
which has a link for further information here.

 

[MisterExcellent]

Re: Solved by Marcelo. Thank you very much, Marcelo

Hello p45cal,

keep cool, please!
There is no need for us to have this debate about crossposting today.
I asked this in other forums (another language) and wrote there Marcelo's solution with a link to his post.
If you want to discuss with me about this, please write a personal message and don't waste your energy here
If you are interested in the failed suggestions for the formula, I would be delighted to send you the link to other forums in a personal message.

I hope that you will be happy for me that I've found the help of Marcelo.

I wish you a nice day and hope for a peaceful way of communicating..

 

[p45cal]

Re: Solved by Marcelo. Thank you very much, Marcelo

Well, that's me told.

 

[barry houdini]

Hello MisterExcellent and Marcelo,

I was looking at your last formula, Marcelo - I don't think you need CSE, by the way, the results should be the same without it - but I did find some discrepancies, e.g. if B5 is 26/05/2007 and C5 is 30/04/2008 then the result returned is 01/05/2008 - 26/08/2007

Also I think there are oddities with dates at the end of the month, e.g.if B5 is 30/05/2003 and C5 is 25/11/2005 then result returned is 26/11/2005 - 02/03/2006......not sure about that second date, what result do you want in that case?

If you don't mind using analysis ToolPak functions then I suggest using this version utilising EOMONTH and EDATE, it should fix the above and also gets the correct results for your table of examples......but whether it works for all combinations of dates I'm not sure.....

=TEXT(C5+1,"dd/mm/yyyy")&" - "&TEXT(EDATE(B5,CEILING(DATEDIF(B5+1,EOMONTH(C5+1,0)+1,"m")+1,3)),"dd/mm/yyyy")

......or this version does exactly the same without add-in functions....

=TEXT(C5+1,"dd/mm/yyyy")&" - "&TEXT(MIN(DATE(YEAR(B5),MONTH(B5)+CEILING(DATEDIF(B5+1,DATE(YEAR(C5+1),MONTH(C5+1)+1,1),"m")+1,3)+{0,1},DAY(B5)*{1,0})),"dd/mm/yyyy")

 

[Marcelo Branco]

Hi Barry.

1. You are right, the formula doesnt require Ctrl+Shift+Enter as CHOOSE generates and array without CSE. (at first i was trying a different solution that required CSE and when changed my mind overlooked this point)

2. When trying to simplify my original-formula i made a mistake (in fact a typo). The correct is

=TEXT(C5+1,"dd/mm/yyyy")&" - "&TEXT(DATE(YEAR(C5),MONTH(B5)+3*MATCH(IF(MONTH(B5)>MONTH(C5+1),MONTH(C5+1)+12,MONTH(C5+1)),CHOOSE({1,2,3,4},MONTH(B5),MONTH(B5)+3,MONTH(B5)+6,MONTH(B5)+9))-12*(MONTH(B5)>MONTH(C5+1)),DAY(B5)),"dd/mm/yyyy")

I think this is OK and produces the proper result if B5 is 26/05/2007 and C5 is 30/04/2008

3. Checking if B5 is 30/05/2003 and C5 is 25/11/2005
(Maybe some adjustment needed)
Mister Excellent, what is the expected result in this case?

Barry, i will try your formula and thanks for your comments (always learning!) .

M.

 

[markmzz]

MisterExcellent,

Try this (use yyyy and not aaaa in your formula):


<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Friends dia</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">Love dia</TD><TD style="TEXT-ALIGN: center; FONT-WEIGHT: bold">First Application - Calc</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">12/12/2010</TD><TD style="TEXT-ALIGN: center">13.12.2010-12.03.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">23/01/2008</TD><TD style="TEXT-ALIGN: center">17/08/2010</TD><TD style="TEXT-ALIGN: center">18.08.2010-23.10.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">07/04/2010</TD><TD style="TEXT-ALIGN: center">08/10/2010</TD><TD style="TEXT-ALIGN: center">09.10.2010-07.01.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">06/11/2011</TD><TD style="TEXT-ALIGN: center">06/11/2011</TD><TD style="TEXT-ALIGN: center">07.11.2011-06.02.2012</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">03/04/2001</TD><TD style="TEXT-ALIGN: center">24/03/2011</TD><TD style="TEXT-ALIGN: center">25.03.2011-03.04.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">11/11/1991</TD><TD style="TEXT-ALIGN: center">03/03/2010</TD><TD style="TEXT-ALIGN: center">04.03.2010-11.05.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">12/08/2008</TD><TD style="TEXT-ALIGN: center">09/12/2010</TD><TD style="TEXT-ALIGN: center">10.12.2010-12.02.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">12/09/2008</TD><TD style="TEXT-ALIGN: center">23/03/2009</TD><TD style="TEXT-ALIGN: center">24.03.2009-12.06.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">23/02/2008</TD><TD style="TEXT-ALIGN: center">03/04/2008</TD><TD style="TEXT-ALIGN: center">04.04.2008-23.05.2008</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">07/05/2010</TD><TD style="TEXT-ALIGN: center">08/05/2010</TD><TD style="TEXT-ALIGN: center">09.05.2010-07.08.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">06/12/2010</TD><TD style="TEXT-ALIGN: center">05/01/2011</TD><TD style="TEXT-ALIGN: center">06.01.2011-06.03.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">03/05/2001</TD><TD style="TEXT-ALIGN: center">03/05/2001</TD><TD style="TEXT-ALIGN: center">04.05.2001-03.08.2001</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">11/12/1991</TD><TD style="TEXT-ALIGN: center">12/01/1992</TD><TD style="TEXT-ALIGN: center">13.01.1992-11.03.1992</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">23/03/2010</TD><TD style="TEXT-ALIGN: center">07/05/2011</TD><TD style="TEXT-ALIGN: center">08.05.2011-23.06.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">16/06/2009</TD><TD style="TEXT-ALIGN: center">02/08/2011</TD><TD style="TEXT-ALIGN: center">03.08.2011-16.09.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">19/08/2009</TD><TD style="TEXT-ALIGN: center">08/08/2010</TD><TD style="TEXT-ALIGN: center">09.08.2010-19.11.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">15/04/2010</TD><TD style="TEXT-ALIGN: center">04/06/2010</TD><TD style="TEXT-ALIGN: center">05.06.2010-15.07.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">20/02/2011</TD><TD style="TEXT-ALIGN: center">03/04/2011</TD><TD style="TEXT-ALIGN: center">04.04.2011-20.05.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">06/09/2010</TD><TD style="TEXT-ALIGN: center">05/04/2011</TD><TD style="TEXT-ALIGN: center">06.04.2011-06.06.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">03/06/2009</TD><TD style="TEXT-ALIGN: center">04/01/2011</TD><TD style="TEXT-ALIGN: center">05.01.2011-03.03.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">04/05/2006</TD><TD style="TEXT-ALIGN: center">29/05/2009</TD><TD style="TEXT-ALIGN: center">30.05.2009-04.08.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">05/06/2007</TD><TD style="TEXT-ALIGN: center">05/07/2007</TD><TD style="TEXT-ALIGN: center">06.07.2007-05.09.2007</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">07/08/2009</TD><TD style="TEXT-ALIGN: center">08/03/2011</TD><TD style="TEXT-ALIGN: center">09.03.2011-07.05.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">10/11/2010</TD><TD style="TEXT-ALIGN: center">03/03/2011</TD><TD style="TEXT-ALIGN: center">04.03.2011-10.05.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">04/07/2008</TD><TD style="TEXT-ALIGN: center">07/07/2008</TD><TD style="TEXT-ALIGN: center">08.07.2008-04.10.2008</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">05/10/2009</TD><TD style="TEXT-ALIGN: center">31/12/2009</TD><TD style="TEXT-ALIGN: center">01.01.2010-05.01.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">31/08/2010</TD><TD style="TEXT-ALIGN: center">28/12/2010</TD><TD style="TEXT-ALIGN: center">29.12.2010-28.02.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">16/11/2004</TD><TD style="TEXT-ALIGN: center">31/07/2005</TD><TD style="TEXT-ALIGN: center">01.08.2005-16.08.2005</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">23/03/2010</TD><TD style="TEXT-ALIGN: center">31/08/2010</TD><TD style="TEXT-ALIGN: center">01.09.2010-23.09.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">31/12/2008</TD><TD style="TEXT-ALIGN: center">11/05/2009</TD><TD style="TEXT-ALIGN: center">12.05.2009-30.06.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">30/11/2004</TD><TD style="TEXT-ALIGN: center">26/11/2005</TD><TD style="TEXT-ALIGN: center">27.11.2005-28.02.2006</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">31/01/2010</TD><TD style="TEXT-ALIGN: center">24/03/2010</TD><TD style="TEXT-ALIGN: center">25.03.2010-30.04.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">13/06/2008</TD><TD style="TEXT-ALIGN: center">31/12/2008</TD><TD style="TEXT-ALIGN: center">01.01.2009-13.03.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">35</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">07/04/2010</TD><TD style="TEXT-ALIGN: center">30/09/2010</TD><TD style="TEXT-ALIGN: center">01.10.2010-07.10.2010</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">36</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">10/08/2007</TD><TD style="TEXT-ALIGN: center">30/04/2008</TD><TD style="TEXT-ALIGN: center">01.05.2008-10.05.2008</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">37</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">01/05/2008</TD><TD style="TEXT-ALIGN: center">30/04/2009</TD><TD style="TEXT-ALIGN: center">01.05.2009-01.05.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">38</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">31/12/2004</TD><TD style="TEXT-ALIGN: center">20/05/2006</TD><TD style="TEXT-ALIGN: center">21.05.2006-30.06.2006</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">39</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">30/08/2006</TD><TD style="TEXT-ALIGN: center">06/12/2007</TD><TD style="TEXT-ALIGN: center">07.12.2007-29.02.2008</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">40</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">20/08/2010</TD><TD style="TEXT-ALIGN: center">27/10/2012</TD><TD style="TEXT-ALIGN: center">28.10.2012-20.11.2012</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">41</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">29/08/2011</TD><TD style="TEXT-ALIGN: center">30/09/2011</TD><TD style="TEXT-ALIGN: center">01.10.2011-29.11.2011</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">42</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">15/07/2008</TD><TD style="TEXT-ALIGN: center">30/09/2009</TD><TD style="TEXT-ALIGN: center">01.10.2009-15.10.2009</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">43</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">25/07/2011</TD><TD style="TEXT-ALIGN: center">30/09/2013</TD><TD style="TEXT-ALIGN: center">01.10.2013-25.10.2013</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">44</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">20/07/2007</TD><TD style="TEXT-ALIGN: center">30/06/2008</TD><TD style="TEXT-ALIGN: center">01.07.2008-20.07.2008</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">45</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: center">27/09/2009</TD><TD style="TEXT-ALIGN: center">28/02/2010</TD><TD style="TEXT-ALIGN: center">01.03.2010-27.03.2010</TD></TR></TBODY></TABLE>


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>D2</TH><TD style="TEXT-ALIGN: left">=TEXT(C2+1,"dd.mm.aaaa")&"-"&TEXT(EDATE(DATE(YEAR(C2),MONTH(B2),DAY(B2)),MONTH(C2)-MONTH(B2)+3-MOD(MONTH(EDATE(B2,MONTH(C2)-MONTH(B2)+3))-MONTH(B2),3)),"dd.mm.aaaa")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


Markmzz