Fortune Telling Collection - Zodiac Guide - How to set the constellation in the table?
How to set the constellation in the table?
Build a query table:
Use the query function to query the above table to obtain constellation information, and the formula is as follows:
= iforror(VLOOKUP(VALUE(MID(D2，7，8)，" 0000-00-00 "))-DATE(YEAR(VALUE(TEXT(MID(D2，7，8)，" 0000-00-00 "))， 1， 1)，A:B，2)，"")
- Previous article:7 19 constellation _7. 19 constellation
- Next article:What constellation is July 14?
- Related articles
- How to save the hearts of Aries boys?
- I want to know something about UFOs on the moon.
- What constellation is Gregorian calendar 1993 438+00.438+0?
- These constellation women are most afraid of being sad _ the constellation women who are most afraid of being hurt.
- Wang's name is meaningful. What about the name Wang?
- What is the constellation of June 13 _ What is the constellation of June 13?
- Constellation girl with bad love
- What do Gemini and Gemini have in common?
- Is there really no sequel to ipartment?
- Constellation Third Party Relationship _ What is Constellation Third Party Relationship?