Lemon8Lifestyle community

Automatically translated.View original post

Excel So Ezy
Excel So Ezy

28.9K followers

Follow
Follow
Follow

6 saved
8

What day was she born?

1/29 Edited to

... Read moreสำหรับใครที่กำลังเริ่มต้นใช้ Excel หรืออยากปรับปรุงการหาวันเกิดให้เป็นระบบมากขึ้น การใช้สูตร WEEKDAY ถือเป็นเครื่องมือที่มีประสิทธิภาพและใช้งานง่ายมากครับ โดยปกติแล้ว สูตร WEEKDAY จะส่งคืนหมายเลขของวันในสัปดาห์ โดยที่ตัวเลขจะเริ่มตั้งแต่ 1 ถึง 7 ซึ่งสามารถกำหนดรูปแบบได้ เช่น 1 = อาทิตย์ ถึง 7 = เสาร์ หรือในบางรูปแบบ 1 = จันทร์ ถึง 7 = อาทิตย์ ขึ้นอยู่กับการตั้งค่า นอกจากนี้ การผสมสูตร WEEKDAY กับสูตร VLOOKUP จะช่วยให้เราดึงค่าชื่อวันภาษาไทยตามหมายเลขที่ได้มากลับมาได้ทันที ผมแนะนำให้สร้างตารางเปรียบเทียบวันในช่วงเซลล์ที่ชัดเจน เพื่อช่วยให้สูตรค้นหาข้อมูลได้แม่นยำ เช่น กำหนดตารางมีหมายเลข 1-7 และชื่อวันที่ต้องการ สำหรับการแสดงชื่อวันแบบเต็มหรือแบบย่อ สูตร TEXT ก็ช่วยประหยัดเวลาได้มาก เช่น =TEXT(B6,"dddd") จะได้ชื่อวันเต็ม เช่น "พฤหัสบดี" หรือ =TEXT(B6,"ddd") สำหรับชื่อย่อ เช่น "พฤ." เทคนิคเล็กๆ ที่ผมแนะนำคือ ควรตรวจสอบให้วันที่ที่ใส่ในเซลล์ต้องเป็นวันที่จริงในรูปแบบวันที่ของ Excel เพื่อให้สูตรทำงานได้ไม่ผิดเพี้ยนครับ ลองนำสูตรเหล่านี้ไปปรับใช้ในชีวิตประจำวันที่ต้องจัดการข้อมูลวันเกิด หรือข้อมูลที่เกี่ยวข้องกับวันในสัปดาห์ รับรองทำงานได้รวดเร็วและหลีกเลี่ยงข้อผิดพลาดบ่อยๆ ได้ดีเลยครับ!

Related posts

Baby girl was born may 29, 2026
She was 5 pounds and 3 oz #csectionmomma #fypシ゚viral #momcreator #viral #unfiltered
Delicia ➡️{momof3}💜💜💜💜

Delicia ➡️{momof3}💜💜💜💜

685 likes

A black and white portrait of Josephine Baker, smiling brightly. She has slicked-back hair, dramatic eye makeup, dark lipstick, and is adorned with large, sparkling earrings and a jeweled top, embodying her iconic glamorous performer image.
On This Day: Josephine Baker is Born
December 24, 1906. The world met Josephine Baker and had absolutely no idea what it was in for. Born in poverty in St. Louis, she grew up in a country that loved her talent but rejected her humanity. America wanted her to dance, smile, perform but not to be safe, equal, or respected. So she did
LataraSpeaksTruth

LataraSpeaksTruth

56 likes

A close-up of a newborn's feet, one showing a limb difference, next to a hospital birth record. The overlaid text "Just a reminder that" emphasizes the baby's unique beginning.
A newborn baby lies on a white blanket, wearing a pink outfit and pacifier. The overlaid text "Mountains don't rise without earthquakes" symbolizes the initial challenges faced.
An X-ray image displays a baby's legs, revealing skeletal differences consistent with fibular hemimelia. The text "Redwoods don't grow without a little rain" refers to necessary medical interventions.
Just a reminder that… she was born different, not broken. 💔➡️💪
“Mountains don’t rise without earthquakes” – from learning to walk with a prosthetic to dancing, running, and living limitlessly. “Redwoods don’t grow without a little rain” – surgeries, fittings, tears… and so much strength. “Gold would just bend without a blue flame” – now she shines brighter t
priscillasoliis

priscillasoliis

4532 likes

Our first born and baby girl will be here any day🤍
She’s due any day now, I still want to call my mom 🥺 #firstborngirl #pregnancyannouncement #griefawareness #motherlessdaughter #pregnancyjourney
Missy

Missy

4695 likes

Nova the day she was born
New to Lemon8! Something I love： #hellolemon8
Novaisluved

Novaisluved

20 likes

Born Free, but now she’s expensive 🇺🇸
It’s our Independence Day today! We have a lot of activities planned and we’re so thankful to be American 🇺🇸 #america #july #july4th #fourthofjuly #lemon8diarychallenge #usa
Lemon8er

Lemon8er

31 likes

She WAS THE…And THE SISTER…WHAT‼️
When I say MOUTH DROPPING TWIST 😳 I am squealing over this book because I haven’t been this excited after reading a thriller in a minute! The fact that the DADDY was the real villain in this story…like you murdered your first born child grandparents and you still took the money,you murder the careg
Katie May

Katie May

216 likes

A baby lies on a light-colored blanket with a white flower covering its face. Text overlays read "THINGS MY HUSBAND HAD TO RUN OUT AND GET Newborn Edition," indicating a list of essential items.
A clear plastic breast pump flange is shown against a white background. The accompanying text emphasizes the importance of proper fitting flanges for a breast pump.
Two clear, ladybug-shaped silicone breast milk collectors are displayed, with their packaging visible in the background. The text recommends these collectors for catching milk drips.
Panic Buys After Baby Was Born: Newborn Edition
I thought I was completely prepared for baby to be born! Then she got here and we realized we still needed some stuff 😅 here are items I recommend buying or at least thinking about buying before you have baby! Again, these are just my experiences and opinions, but every baby and mom is different! W
Life With Eileen

Life With Eileen

105 likes

My 👵 was born 1896-1995 she was 99 years pass way
#Lemon8Diary #tea #foryou #foryoupage #healthy
Mrrice🌾

Mrrice🌾

71 likes

The amount of days I got to spend with my mamafrom the day I was born to the da
Steph.Ann.

Steph.Ann.

449 likes

A woman with long brown hair showcases a 1970s-inspired makeup look, featuring vibrant orange and yellow eyeshadow, bold winged eyeliner, and a nude lip. She wears a floral top and a sun pendant, embodying a retro aesthetic with text overlays.
🧡Doing makeup like the year my mom was born🧡
Doing my makeup like the year my mom was born ✨ 1970s Style. Channeling 70s glam 🪩—sunset eyes with the Ace Beaute Flair Palette, golden glow from Fenty Trophy Wife, and a soft flush using bareMinerals Gen Nude Blush. Liner + lashes stayed bold with Sheglam Eyeliner & Benefit Bad Gal Bang, w
Juliet C.

Juliet C.

24 likes

A red Valentino Born In Roma Extradose perfume bottle and its pink box are displayed. The bottle has a textured design and black cap. Overlays show key fragrance notes like cassis and vanilla, along with the product name.
A hand holds a red Valentino Born In Roma Extradose perfume bottle, showcasing its textured design and black cap. Numerous other perfume bottles are visible on shelves in the background, indicating a collection.
A collection of various Valentino Born In Roma perfume bottles, including the red Extradose, are neatly displayed on clear risers. The bottles feature different colors and sizes, all with the signature textured design.
‼️‼️NEW VALENTINO BORN IN ROMA 💕 EXTRADOSE ‼️‼️
💵 Price: $198 𝓚𝓮𝔂 𝓝𝓸𝓽𝓮𝓼: Cassis Accord, Rhum Accord, Vanilla Extract Rate: 10 out of 10 After stalking Valentino website, I was able to purchase this beauty. This smells so good but I honestly thought this is what Born In Roma Intense would’ve smelled like but overall it’s still a great scent.
𝓛𝓪𝓣𝓸𝔂𝓪 𝓢𝓱𝓪𝓝𝔂𝓬𝓮🌹

𝓛𝓪𝓣𝓸𝔂𝓪 𝓢𝓱𝓪𝓝𝔂𝓬𝓮🌹

67 likes

Best Born Day to date #birthday #cabin #newyear
This past 18 months has reshaped me in ways I never saw coming! I’ve stepped into the chapter where everything finally aligns ✨ where my ancestors move with me like an entourage 🕊️, and where my mama, now among them, guides me from a higher realm 👼🏾. I traveled over 30,000 miles 🚐💨 in my VillaVan,
Sheri Ben the AstroAccountant

Sheri Ben the AstroAccountant

1 like

I Don’t Know When I was Born (Part 1/2)🇭🇹🎀
🎀 I don't know when I was born but, I don't let that stop me from celebrating the gift of me. Every October it’s all about me 🎉 Make sure you’re following me for part 2 where I give tips for anyone struggling with mixed emotions on your birthday. 🌸 Im adopted from Haiti by a white famil
Sarah The Diva 🎀

Sarah The Diva 🎀

108 likes

Tina Turner… Born November 26, 1939
Every once in a while, a voice shows up that doesn’t just sing… it shifts the whole room. Tina Turner was one of those voices. Born in Nutbush, Tennessee, she grew from a small-town girl with a spark into one of the most electrifying performers the world has ever seen. Her story isn’t just music
LataraSpeaksTruth

LataraSpeaksTruth

12 likes

A young woman with dark braided and curly hair, wearing a dark blue tank top. She has prominent eye makeup with dark eyeliner and light inner corners, and glossy lips, reflecting a 2009 makeup style.
A young woman with dark braided and curly hair, wearing a dark blue tank top, is shown with a bright light flare across her face. Her makeup features dark eyeliner and light inner corners.
A young woman with dark braided and curly hair, wearing a dark blue tank top, poses in front of a mirror. Her makeup includes dark eyeliner and light inner corners, with a light reflection visible.
I did her makeup the year she was born 2009
#2009makeup #makeupideas
Sharshar

Sharshar

8 likes

A close-up of a newborn baby sleeping peacefully, wrapped in a white blanket and wearing a white knotted hat. The baby's eyes are closed, and their face is visible.
The day she was born 🥹Toni🌸
Lemon8er

Lemon8er

1 like

A pregnant person takes a mirror selfie, showing their baby bump. The image is overlaid with the title text, "What no one tells you New born babies," introducing an article about unexpected aspects of the newborn stage.
A newborn baby, wearing a patterned sleepsuit and hat, lies on its back with a pacifier. Text overlays highlight key points about newborns: "All they'll do is eat and sleep," "Your relationships will change," "How important sleep safe is," and "Fed is best as long as baby eats."
A baby lies on its stomach in a bassinet, next to a black and white soft book. Overlaid text lists more insights about parenting a newborn: "There are a lot of doctors appointments," "People will push your boundaries," and "People will tell you how to parent."
What no one tells you about new born babies!
I find myself grieving my boys’ new born stage all the time😭 I miss how little they were. As I think back to that time I started thinking about how much I learned and experienced that I wasn’t warned about it able to prepare for. I wanted to share my thoughts! 🍼 All babies do ate eat and sleep:
Mariana • sahm

Mariana • sahm

299 likes

A silhouette of a person stands on a textured ground, with the sun shining brightly from their chest. The person's shadow shows a peace sign. The words "Born" and "UNFILTERED" are overlaid, reflecting the article's theme of new beginnings after grief.
Born
My house holds a lot of trama for me. It’s where my marriage fell apart, where I self sabotaged and let monsters in and where my daughter spent the last years of her life. Every single room but one closet holds bad memories. Why not just pack up and move you ask? How? How do I overcome the paralysi
Ali Kinnebrew

Ali Kinnebrew

4 likes

How she was born 🥺
#bookrecommendations #newbooks #booksoflemon8 #readersoflemon8 #dystopian
andralarkin 📚✍🏼

andralarkin 📚✍🏼

2 likes

Meet villa she was born 8/30/25.
Meet Viloa, this black beauty was born 8/30/25. She weighed 3.5 oz. Black Mi-Kis are elegant! E
YORKIE | +1 332-223-2664

YORKIE | +1 332-223-2664

10 likes

A man with a beard and a nasal cannula lies in a hospital bed next to a young girl, both looking at the camera. Overlay text describes him as her hero and recounts a poignant hospital conversation about his final moments.
her hero since the day she was born. he was in aw
widowedAt43_cancerStoleUaway

widowedAt43_cancerStoleUaway

1 like

A smiling girl in a '1989' sweatshirt and sunglasses makes a peace sign in front of a Five Nights at Freddy's (FNAF) themed birthday setup. The decorations include a 'HAPPY BIRTHDAY' banner, a character backdrop, and a tablecloth, with gifts on the table. Text overlay reads: 'What Made My Day? My firstborn baby girl turned TEN'.
My firstborn baby girl turned TEN
What made my day today? My firstborn, Scarlett Marie, turned 10. 😭🥹🖤 She is literally the coolest little chick. She’s beautiful, talented, and so incredibly smart. Also, she loves all things spooky, Halloween, and horror, just like her Mama. (Peep the FNAF decor). I’m so thankful she chose
Amanda Robinson

Amanda Robinson

15 likes

PhoreverBrooklyn was born at 1 pound this is my girly girl stories below
#lemon8challenge #lemon8badgehunt They say miracles come in small packages… well mine came in at 1 pound, 24 weeks, and a whole lot of attitude 💅🏽 Meet my baby girl PhoreverBrooklyn — yes, ALL 16 letters of her name, because regular wasn’t going to cut it over here. I always loved the name For
Coach Kimberly

Coach Kimberly

108 likes

Best friends since she was born🥰
rosamontero

rosamontero

2 likes

A new mother in a hospital bed with her newborn baby in a bassinet, flanked by two women, illustrating the article's theme of rules for new moms. Text overlays include "Rules I had for when my son was born."
A baby, the son mentioned in the article, sits on a gray sofa wearing a striped onesie, showcasing the child for whom the mother set boundaries.
The baby from the article lies on a bed, dressed in a white Nike onesie and a hat, representing the son whose birth prompted the mother's rules.
rules I had when my son was born 😎
#lemon8diarychallenge Here are some of my rules/ boundaries I had in place when my son was born and why.. ❤️Limited visitation at the hospital. I only allowed immediate family and a close friend at the time to meet him the day of/ after his birth and then after that it was only my mom and
k.marie

k.marie

727 likes

Her momma died when she was born
#lemon8diarychallenge
Arkansas GSDs

Arkansas GSDs

11 likes

Donna Born in Roma Ivory & 💨 Uomo Born in Roma
Introducing @valentino.beauty ✨ 💗 Donna Born in Roma Ivory & 💨 Uomo Born in Roma Ivory Here’s my thoughts 🥰 Meet Ms. Donna Born in Roma Ivory herself 💕 She’s been the talk of the town and I finally got to try her! To me, she’s soft, pretty, slightly sweet & floral 🌸💖. The opening rem
Jada✨

Jada✨

94 likes

Tomorrow is Oreo birthday there when Oreo was born
Now he is 14. There pic of him mommy cat. She only had one kitty.
Precious

Precious

29 likes

My Marley 🎀Girl was born 10/11/2024
I am so overwhelmed and tired 😂😂😂 She the beginning of our new chapter!!
Sonni Sills

Sonni Sills

317 likes

She was born in July, so we gave her a snowflake.
Her name begins with a “P”, and her birthday falls in midsummer. He didn’t say much, just asked: “Can we place a snowflake next to this letter?” The pendant is golden — warm, luminous. The snowflake is cool — subtle, delicate. Like her: bright on the outside, winter on the inside. That
Aurora Aura Jewelry

Aurora Aura Jewelry

5 likes

My Travel Era Was Born From This One Moment!
WHY I Fell in Love With Traveling? SIMPLE! 🎀 The EXCITEMENT of Seeing Something New : There’s just something about the thrill of discovering a new place — everything feels fresh and exciting. 🎀 The JOY of EXPLORING New Places : I love wandering through unfamiliar streets, just soaking i
courtneyjolla

courtneyjolla

2 likes

A page from Numbers 21 (NIV) detailing Israel's wars with Canaanites and Amorites, their complaints, God sending snakes, and Moses making a bronze snake for healing. Key verses are highlighted.
A continuation of Numbers 21 (NIV) describing the Israelites' journey to Moab, their defeat of Sihon and Og, and taking possession of their land. Key verses and poetic excerpts are highlighted.
A continuation of Numbers 21 (NIV) detailing Israel's defeat of Og king of Bashan and taking his land. The page also includes NIV footnotes and copyright information for the Bible translation.
Numbers 21 WHAT IT MEANS TO BE BORN AGAIN
#Numbers #biblejournaling #biblestudy #2024 #God #study The Israelites go to war After Aaron’s death the Israelites entered into a period of being at war. As they traveled toward their final destination they came into contact with Canaanites, Moabites, and Amorites. God was with the
E'pip-hany

E'pip-hany

2 likes

Rules we had when our son was born
#mybirthstory #lemon8challenge #storytime #letschat Part 2! 1. Do not drop by to visit without asking us and do not expect me to cook for you, make you a drink, etc. (you’d be surprised with how people will act like the woman literally recovering from childbirth should be playing hostess
Shay

Shay

23 likes

A graphic featuring the title 'The Legendborn Cycle review' with a sword icon, showcasing the covers of three books: 'Legendborn,' 'Bloodmarked,' and 'Oathbound' by Tracy Deonn. Text below highlights themes like 'Modern retelling of Arthur,' 'Racism,' 'History of slavery,' 'Black southern history,' and 'Grief,' with a '10/10' rating.
The Legendborn Cycle Review🗡️✨
I wanted to finish Oathbound so I can give you guys my complete thoughts. If you've been hesitant on reading this series then this is your sign to go and get you a copy of these three books because trust me you'll never be the same after you read these books. The legendborn cycle is a moder
�𝐚𝐲𝐨౨ৎ⋆ ˚｡⋆

𝐚𝐲𝐨౨ৎ⋆ ˚｡⋆

92 likes

Mommas born in the 90s, your kids need this!!!
Forreal I’ve been waiting for the day she’d want to read this with me and she’s been all about it today. I got these for her before she was born and I’m so excited the day is finally here. My inner child is screaming and forreal how cute are the illustrations!? If your a mom from the 90s who loves
dunnfamilyfun

dunnfamilyfun

6 likes

What sign was your soulmate born under?
#ManifestationLove #cosmiclove #soulmate #twinflame #ZodiacMatch
Mikaela.with.love

Mikaela.with.love

7 likes

A Lemon8 star was born🍋
This is the face of a girl who KNEW she’d be a star on Lemon8 xoxo #Lemon8Diary #dayinmylife #embracevulnerability #throwback #newfriends
Tali Rabinowitz🤍

Tali Rabinowitz🤍

1 like

She was born to be the best mom 🐾💖
First time mommy, first time love… and she’s already doing an amazing job 💖🐾 Watching her feed and care for her baby melts my heart every single day 🥹✨ So proud of this beautiful mama 💕#MiniGoldendoodle #GoldendoodlePuppies #DoodleLife #DoodleLove #PuppyLove #PuppyReels #PuppyVideo
Doodle Dream Babies

Doodle Dream Babies

1 like

A close-up, tilted shot of a person with dark hair, wearing a blue top, glossy red lipstick, and sparkling jewelry. The image features decorative white star outlines and sparkle effects, with 'Lemon8 @dear.rachel' and 'dear.rachel' text overlays.
Yeah, I was born to shine.
She healed, stayed soft, and still broke necks. Don’t ask me how—I’m just built like that. #MainCharacterEnergy #DearMeAndCo #GlowDifferent #ProtectedAndUnbothered
Dear.Rachel

Dear.Rachel

12 likes

See more