hi
Yes that does exactly what i need to be done... Thank you!!! but
now
I need the all people that have birthday to day or tomorow or day
after to apear on a userform. (take note that there maybe more than
one sharing a birthday)
i use label34 (today) and label35 (tomorow) and label36 (day a
Hello, Phillip,
Handle this by step by step.
1. IN column E Put the Heading
Date in the Current Year.
add fomula in E8
=DATE(YEAR($B$2),MONTH(B8),DAY(B8))
2. In column F put
Birthday falls in No. of days
add formula in F8
=E8-$B
Hi Phillip,
Please find attached the solved workbook.
Do let me know if it helps or you need further help.
I have added some other features other than your requirement which I felt
might come handy, as well, which will predict the following:
Today (As required)
Tomorrow (As required)
Day After (A
Hi all
Attached is a sample work book.
In column b down i got birthdays. next to that the persons name.
B2 will be either =today() or =now() (or something else that will trigger
the days date...
how can i display in a column who has a birthday today or tomorrow?
Phillip Swanepoel
pswa...@g
