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:
adee la Simpatie.ro
 | Femeie
24 ani
Mures
cauta Barbat
24 - 59 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2189
|
|
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 10 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2189
|
|
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 9 ani |
|