remember birthday

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

Row\Col	A	B	C	D
1			today
2			9/9/15
3
4
5	name	birthday	Next Bday
6	James	11 Aug 1977	11 Aug 2016	C6: =EDATE(B6, 12*(DATEDIF(B6 + 1, $C$2, "y") + 1))
7	John	25 Jun 1975	25 Jun 2016
8	Richard	03 Jul 1980	03 Jul 2016
9	Charles	05 Dec 1972	05 Dec 2015
10	George	26 Jul 1978	26 Jul 2016

Sort by the Next Bday column.

probably Edate problem with 2003

see workaround
http://answers.microsoft.com/en-us/o...4996ac8?auth=1

Originally Posted by manos77

find the name

Hi Mannos

..... Maybe
http://gr.excel-translator.de/
http://gr.excel-translator.de/translator/

.. shg Formula is very clever. It works good.

.. I have done you another very simple Formula

Using Excel 2007

Row\Col	A	B	C	D	E
1			today
2			10.09.2015
3
4
5	names	birthday		birthday today
6	James A	11.08.1977	11.08.2016
7	Johny B Good	25.06.1975	25.06.2016
8	Richards	03.07.1980	03.07.2016
9	Charles Wells	05.12.1972	05.12.2015
10	George W___	10.09.1972	10.09.2015	George W___	birthday today
11					George W___
12
13					write name

F????1 (2)

................................

Using Excel 2007

Row\Col	A	B	C	D	E
1			today
2			=TODAY()
3
4
5	names	birthday		birthday today
6	James A	11.08.1977	=EDATE(B6, 12*(DATEDIF(B6 + 1, $C$2, "y") + 1))	=IF($C$2=C6,A6,"")
7	Johny B Good	25.06.1975	=EDATE(B7, 12*(DATEDIF(B7 + 1, $C$2, "y") + 1))	=IF($C$2=C7,A7,"")
8	Richards	03.07.1980	=EDATE(B8, 12*(DATEDIF(B8 + 1, $C$2, "y") + 1))	=IF($C$2=C8,A8,"")
9	Charles Wells	05.12.1972	=EDATE(B9, 12*(DATEDIF(B9 + 1, $C$2, "y") + 1))	=IF($C$2=C9,A9,"")
10	George W___	10.09.1972	=EDATE(B10, 12*(DATEDIF(B10 + 1, $C$2, "y") + 1))	=IF($C$2=C10,A10,"")	birthday today
11					=D6 & D7 & D8 &D9 & D10
12
13					write name

F????1 (2)

....

. Array Formula ( CSE ) is better maybe?. I not know how. Sorry. Maybe someone else can help here, I am sure it can be done

. Maybe my simple Formula helps a little ?

Alan

Hi Mannos,

. 1)

Originally Posted by manos77

Thanks alan.
......

Did the Formula from me and shg work good ?

Alan

Hi humdingaling

Originally Posted by humdingaling

probably Edate problem with 2003
...

. can you elaborate?? The OP has .xlsx files, so is presumably using XL 2007 + ,. And probably has just problems with copying in a formula etc.. I did not understand what you were getting at
Thanks
Alan

Originally Posted by Czeslaw

Formula:

Please Login or Register  to view this content.

. Wow, I do not think I have time to break it down to understand it, but it works great!
Alan

Sorry Alan
i was reading the profile of the user (XL2003)
i go by the the file

Originally Posted by humdingaling

Sorry Alan
i was reading the profile of the user (XL2003)
i go by the the file

?? His Profile shows XL2010 by me?? and all his Files were .xlsx or .xlsm ???
.
........................
.
. Also I think the error mannos got is the typical one got when attempting to type in a formula of wrong syntax. I was initially expecting maybe he had problems with converting the formula to the Greek formula language. So i supplied him links to Excel Formula Translation sites.
.
. But I note when I translated an English formula to Greek using that site the formulas came back in English. I do not know if there are indeed different formulas in Greek. There certainly are in German.
.
. mannos has had the formula and solution “given on a plate” now with a file, which he eventually usually seems to need.
. As I said, In my German system my Formulas are in a different language to English, so if given in English I must convert manually or use the Translation sites I referenced. But in such a case I do find it very helpful if someone supplies me with a File. This is because when I open the English File ( with English formulas in it ) in my German Excel, then the formulas are automatically converted to German.
. Anyway mannos appears Happy.

.
. Out of interest I would be interested if any Greek speakers / user out there can tell me if Greek Excel has different formula conventions,.. This would help me in future to help people like mannos. Unfortunately mannos has great difficulty understanding English so could not advise me of that when I ask, making helping him even more difficult
.
. can anyone answer that question . Are indeed Formulas different in Greek Excel versions. I was unable to Google a quick answer on that one?
Thanks
Alan

profile was just updated

Originally Posted by Indi_Ra

Hi,

sgh formula is good.
The problem with OP is "regional settings"!. He/she, use ";" not "," in formula.
so shg formula will be:
=EDATE(B6;12*(DATEDIF(B6 + 1; $C$2; "y") + 1))

...you are correct Thanks, I overlooked that:

English C6: =EDATE(B6, 12*(DATEDIF(B6 + 1, $C$2, "y") + 1))
German C6:=EDATUM(B6; 12*(DATEDIF(B6 + 1; $C$2; "y") + 1))
Greek C6: =EDATE(B6; 12*(DATEDIF(B6 + 1; $C$2; "y") + 1))



Thanks Indi_Ra
Alan

@ humdingaling

Originally Posted by humdingaling

profile was just updated

..I did not see any change, sorry.
.....................................................

@ mannos

Originally Posted by manos77

.....
I have another question
http://www.excelforum.com/non-englis...tically-2.html

Originally Posted by manos77

change columns

http://www.excelforum.com/non-englis...ml#post4185849

.................
. 1 ) It is preferred at Excel Forum if you could start a new Thread for a new Question. If you do that you can reference the previous Threads if you feel that they are relevant. So you would start the new Thread with:

“.... This Thread follows on from
http://www.excelforum.com/non-englis...ml#post4185849
http://www.excelforum.com/excel-gene...ml#post4186055
......”....................

. 2) It is not clear to me what you require in your new question.
. 2a) If you start a new Thread please try to explain more clearly both in the Thread as asked by FDibbins
http://www.excelforum.com/excel-gene...ml#post4185544
and
. 2b) Please give a clear “Before” and “After”, in separate sheets or in two files. And please state clearly what it is you do that should cause the “Before “ to change into the “After”

Alan

Originally Posted by jason.b75

.....
My guess would be that Greek language excel requires semicolon delimited formulae, not comma delimited, and that the OP has copied the formula directly from shg's post.

Thanks, I expected that too, eventually after Indi_Ra reminded me of that subtle difference in the Greek and German Formula version, the ; , which I had overlooked.... see posts #16 and # 17 etc.
. So I think we are all in agreement now...the OP too!.....
..........................
. In any case the File I gave the op originally had English, Greek and German Formula versions in it, and a full working File, which as I mentioned i expect would come up in his Excel version with the Formula automatically corrected to his Excel version / Language.
. In such a formula case that is one sitution I find someone giving me the file very useful. The formula is then automatically corrected to the users system

.. I think the OP is happy now anyway, and has the formula up and working ( Due his difficulty with English language I expect he is overwhelmed now anyway with all the help he has got here!!

Alan

Hi Mourad,

Originally Posted by maninweb

..... if the excel functions have been translated to Greek,
I can say: No. Only the error codes have been translated. That's why Greek is in the country list for the translator tool. I added the Greek error
codes here............

... Thanks for coming in with that, so we have it really clear now that Excel Formulas are the same in Greek and English ( Except that the “,” in English formulas is replaced with a “;” in the Greek formula, as I obtained ( but overlooked initially ) in the Formula I got from your Translator
. Thanks also for adding the extra error info.
. And thanks very much for your Translator Tool. I have found it very useful in converting English formulas to use in my German Excel
Alan