Birthday dashboard

[jonnie]

Hi, question, I have a list with 500 employes. I want to make a birthday dashboard and see today's  birthday and 2 days ahead. Can anybody help me a bit further?
Thanks Jonnie 

[Alexander Ivanov]

Hi Jonnie

I'd like to help

Do you have any Sheet as a sample to begin?

Cheers Alex

[Alexander Ivanov]

How about this https://docs.google.com/spreadsheets/d/1v5jSO4zZbWWsro1t2bTHfhp68G9XgpEPDp788sfCD1Q/edit?usp=sharing

Various events available

Formula fields have a gray background color and bold italic text

Use sorting to always see the nearest dates

I hope I help

[Alexander Ivanov]

If you need a report from your data you can try the next formula

=ARRAYFORMULA( LET( _event_date,Birthday_dashboard[Event date], _birthday,Birthday_dashboard[Contact], _event_now,DATE(YEAR(TODAY()),MONTH(_event_date),DAY((_event_date))), _count_days,IF(_event_now<TODAY(),DATE(YEAR(TODAY())+1,MONTH(_event_date),DAY((_event_date)))-TODAY(),_event_now-TODAY()), {"Contact","Even date","Event in this year"; SORT(FILTER({_birthday,_event_date,_event_now},_count_days<4),3,1)} ))

https://docs.google.com/spreadsheets/d/1v5jSO4zZbWWsro1t2bTHfhp68G9XgpEPDp788sfCD1Q/edit?gid=1554607105#gid=1554607105&range=C2

Cheers, Alex!

[jonnie]

Hi Alex, I have a new spreadsheet can you help me to make a dashboard?
Thanks al lot.

regards Jonnie

Op dinsdag 25 juni 2024 om 08:22:09 UTC+2 schreef Alexander Ivanov:

[Alexander Ivanov]

Hi Jonnie

Just create a new topic

Cheers!