hi
how can i set a function that gives me my members birthday whenever i open
excel. ex: like in outlook you have a pop up menu when you open it to tell
you happy birthday. does such a function exist in excel or access. thanks

jiana

I'd use an adjacent column--formatted in big red letters:

=if(a2=today(),"Happy Birthday to: " & b2,"")

With the bday in A2 and the name in B2.

It's not quite a popup message, but it's easier and maybe it'll suffice.

jiji wrote:

hi
how can i set a function that gives me my members birthday whenever i open
excel. ex: like in outlook you have a pop up menu when you open it to tell
you happy birthday. does such a function exist in excel or access. thanks

jiana

--

Dave Peterson

thanks for answering. but something wrong with my formula becase it shows
False once it is today's date. this is my formula: if a1 = today();
b1="happy birthday" if not "". what is the & means?
"Dave Peterson" a écrit dans le message de news:
...
I'd use an adjacent column--formatted in big red letters:

=if(a2=today(),"Happy Birthday to: " & b2,"")

With the bday in A2 and the name in B2.

It's not quite a popup message, but it's easier and maybe it'll suffice.

jiji wrote:

hi
how can i set a function that gives me my members birthday whenever i
open
excel. ex: like in outlook you have a pop up menu when you open it to
tell
you happy birthday. does such a function exist in excel or access. thanks

jiana

--

Dave Peterson

I put the birthdate in A2. I put the person's name in B2.

=if(a2=today();"Happy Birthday to: " & b2; "")

If your birthday were today and you had "Jiji" in B2,
then you'd see:

Happy Birthday to: Jiji
in the cell with the formula.

If it wasn't your birthday, the cell would look blank ("").

The & operator is the concatenation symbol. It's used when you want to join
text:

="Hello" & " " & "There"
will look like:
Hello There

"" is just an empty string so that looks blank.


jiji wrote:

thanks for answering. but something wrong with my formula becase it shows
False once it is today's date. this is my formula: if a1 = today();
b1="happy birthday" if not "". what is the & means?
"Dave Peterson" a écrit dans le message de news:
...
I'd use an adjacent column--formatted in big red letters:

=if(a2=today(),"Happy Birthday to: " & b2,"")

With the bday in A2 and the name in B2.

It's not quite a popup message, but it's easier and maybe it'll suffice.

jiji wrote:

hi
how can i set a function that gives me my members birthday whenever i
open
excel. ex: like in outlook you have a pop up menu when you open it to
tell
you happy birthday. does such a function exist in excel or access. thanks

jiana

--

Dave Peterson

--

Dave Peterson

thank you so much.
"Dave Peterson" a écrit dans le message de news:
...
I put the birthdate in A2. I put the person's name in B2.

=if(a2=today();"Happy Birthday to: " & b2; "")

If your birthday were today and you had "Jiji" in B2,
then you'd see:

Happy Birthday to: Jiji
in the cell with the formula.

If it wasn't your birthday, the cell would look blank ("").

The & operator is the concatenation symbol. It's used when you want to
join
text:

="Hello" & " " & "There"
will look like:
Hello There

"" is just an empty string so that looks blank.


jiji wrote:

thanks for answering. but something wrong with my formula becase it shows
False once it is today's date. this is my formula: if a1 = today();
b1="happy birthday" if not "". what is the & means?
"Dave Peterson" a écrit dans le message de
news:
...
I'd use an adjacent column--formatted in big red letters:

=if(a2=today(),"Happy Birthday to: " & b2,"")

With the bday in A2 and the name in B2.

It's not quite a popup message, but it's easier and maybe it'll
suffice.

jiji wrote:

hi
how can i set a function that gives me my members birthday whenever i
open
excel. ex: like in outlook you have a pop up menu when you open it to
tell
you happy birthday. does such a function exist in excel or access.
thanks

jiana

--

Dave Peterson

--

Dave Peterson