Zodiac signs | Excel insta styl 22

In this short Excel tutorial, you'll see how to find zodiac sign based on date of birth. Excel insta style 22
How to find zodiac sign based on date of birth in Excel❓
1. We start by creating a table with the starting day of each zodiac sign.
2. We convert the date of birth to months and days with leading zeros:
TEXT(A2,"mm.dd")
3. We search for the modified date in the list of zodiac signs:
=VLOOKUP(TEXT(A2,"mm.dd"),$D$2:$E$14,2,1)
4. Voilà... You found your zodiac sign from your date of birth in Excel✨
👯‍♀️ Mark a friend who would also like this tip and follow for more tips!
Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.c...
================
Files to download in the Eng folder on the website:
exceliadam.pl/y...
You can also find me on:
📚Blog - excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelInstaStyle #ExcelAndAdam #excel