birthday reminder

[Tia]

Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year

Thank you in advance

 

[KARL DEWEY]

?? a birthday report to know who's birthday is today
Birthday_Today: Format([DOB],"mmdd")
with criteria --
Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays: DateSerial(2222,Month([DOB]),Day([DOB]))
with criteria --
Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5

 

[Tia]

?? a birthday report to know who's birthday is today
Birthday_Today:  Format([DOB],"mmdd")
    with criteria --
               Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays:  DateSerial(2222,Month([DOB]),Day([DOB]))
    with criteria --
            Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5

--
Build a little, test a little.

Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year

Thank you in advance
.- Hide quoted text -

- Show quoted text -

Hello i am trying to put it in the querry but i am receiving that
undefined diff 2 dates function in expression
Please help i am new in excel

 

[KARL DEWEY]

Please help i am new in excel
The newsgroup is for Access and what I posted was for that application and
not Excel.

--
Build a little, test a little.

?? a birthday report to know who's birthday is today
Birthday_Today: Format([DOB],"mmdd")
with criteria --
Format(Date(), "mmdd")

But that is not good - what about the person whose birthday falls on
Saturday, Sunday, Holiday, or any day the office is not open?

This for birthday today or within 5 days --
Birthdays: DateSerial(2222,Month([DOB]),Day([DOB]))
with criteria --
Between DateSerial(2222, Month(Date()), Day(Date()) AND
DateSerial(2222, Month(Date()), Day(Date())+5

--
Build a little, test a little.

Dear,
I have a list of employees with a list of birthdays, I'm trying to set
a birthday report to know who's birthday is today .
What formula should I use to give me the month and the day for this
year

Thank you in advance
.- Hide quoted text -

- Show quoted text -

Hello i am trying to put it in the querry but i am receiving that
undefined diff 2 dates function in expression
Please help i am new in excel
.