Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: Ioana Deea 24 ani
| Femeie 24 ani Prahova cauta Barbat 24 - 49 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 18 ani
Postari: 2241
|
|
Thanks goes to user Mike from office-archive.
---
I am using Office 2010. Please note this is not working if your write birth dates before year 1900.
1. Column A will be used to insert people's birth dates, starting from A2 and going downwards. Select entire column, right click - FORMAT CELLS. From the list on the left select DATE. Now on the right, from the drop-down list, for LOCALE (LOCATION) select ENGLISH (U.S.) and for date format select the one at the bottom of the list: "14-Mar-2001". Insert your birthday in cell A2. Assuming your birthday is 28 march 1988, please insert 28.03.1988 in cell A2.
2. Column B will be used to insert our formula (we will get back to this column at step 6). Leave it empty for the moment.
3. Column C will be used to insert reference dates for zodiac signs. Please set it up just like you did for column A (right click, format cells, etc). Then insert the following into column C, starting from C2: 01.01.2013 20.01.2013 19.02.2013 21.03.2013 20.04.2013 21.05.2013 22.06.2013 23.07.2013 23.08.2013 23.09.2013 24.10.2013 22.11.2013 22.12.2013
4. Column D is for naming zodiac signs, starting from D2. They will be named according to the dates: Capricorn Aquarius Pisces Aries Taurus Gemini Cancer Leo Virgo Libra Scorpio Sagittarius Capricorn Yes, they are 13 instead of 12. Note that Capricorn appears twice.
5. You will have to name a range. Please select cells C2 to D14, then go to the FORMULAS tab, select DEFINE NAME (it's somewhere in the middle of the ribbon), name it "zodiac" (without the quotation marks) and hit OK.
6. Back to column B. Insert the following formula into cell B2: =VLOOKUP(DATE(2013;MONTH(A2);DAY(A2));zodiac;2)
If it's not working, change the ; in the formula with ,
When you hit enter it should show your zodiac sign in cell B2.
_______________________________________
|
|
pus acum 11 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 18 ani
Postari: 2241
|
|
For step 5, could change the formula to this: =VLOOKUP(DATE(2013,MONTH(A2),DAY(A2)),C2:D14,2), then you don't need to worry about defining a range name, etc.
Credits to: DisabledVet
_______________________________________
|
|
pus acum 10 ani |
|