Automatically translated.View original post

28.3K followers

Follow

Follow

Follow

54 saved

59

Create an operating calendar, excluding holidays

Want to create an operational calendar but have to wait to delete the special holiday Saturday / Sunday by yourself. Try this method. It's a lot easier. 😎💚# excelsoezy # Excel # Exceltricks # exceltips # Lemon 8 Howtoo

2/4 Edited to

นอกจากการสร้างปฏิทินงานใน Excel ที่ไม่รวมวันหยุดสำคัญอย่างเสาร์อาทิตย์และวันหยุดพิเศษแล้ว ยังสามารถปรับใช้กับ Google Sheets ได้เช่นกัน แม้จะไม่มีฟังก์ชัน WORKDAY.INTL ตรงๆ แต่ก็สามารถใช้สูตรหรือสคริปต์ช่วยคำนวณวันทำงานได้คล้ายกัน สำหรับคนที่ต้องการให้เลือกวันที่สะดวกขึ้นในการกรอกข้อมูล แนะนำใช้ date and time picker ฟรี ที่มีให้เลือกใน Excel หรือ Google Sheets ซึ่งช่วยลดข้อผิดพลาดในการกรอกวันที่และเพิ่มความรวดเร็วในการทำงาน ในกระบวนการจัดการปฏิทินการทำงาน แนะนำให้เตรียมรายชื่อวันหยุดประจำปีไว้ล่วงหน้า และบันทึกไว้ในตารางแยกเพื่อเรียกใช้งานในสูตร จะช่วยให้การอัปเดตและจัดการง่ายขึ้นเมื่อมีวันหยุดพิเศษใหม่ๆ เพิ่มเข้ามา หากสนใจสร้างปฏิทินแบบละเอียด อย่าลืมปรับรูปแบบวันที่ในเซลล์ให้เหมาะสม และทดลองคัดลอกสูตรลงในเซลล์ต่างๆ เพื่อดูว่าการคำนวณปรับเปลี่ยนวันทำงานอย่างถูกต้องหรือไม่ ประสบการณ์ตรงช่วยให้เข้าใจและปรับใช้ได้จริง

Related posts

An overhead view of several people's feet in blue scrubs and white sneakers, standing in a circle on concrete. The text overlay reads 'HOW TO SURVIVE NURSING SCHOOL'.

A person in blue scrubs takes a mirror selfie in a bathroom, holding a phone. Text overlay states: '#1- KNOW THAT YOU GOT ACCEPTED FOR A REASON!!! YOU ARE CAPABLE TO DEAL WITH THE STRESS AND WORKLOAD THAT COMES WITH IT!'

A green, red, and white 'Children's' medical helicopter is parked outdoors under a blue sky. Text overlay advises: 'IMMEDIATELY START TRYING TO MAKE FRIENDS... STUDY GROUPS ARE AMAZING FOR SOME!'

HOW TO SURVIVE NURSING SCHOOL🩺

you’ve got this! #school #nursing #nursingstudent #nursingschool #nursingjourney

3462 likes

#prenursingstudent #medicalterminology #urinarysystem Notes by me

467 likes

asked the OG it girl what perfume she’s wearing 🤭💗 (pinch me) I LOVE that @Rare Beauty is doing another Rare Impact Fund and donating 100% of proceeds on their fine fragrances from @sephora (10/10-10/12) to honor World Mental Health Day 🥹, it makes me so happy & grateful I was chosen to be a part o

4427 likes

A dorm room features a bed with pink 'HOWDY HOWDY' pillows and a pink blanket. Wall decor includes a framed quote and a pink boot illustration. A shelf holds a plant and other items, suggesting a cozy, personalized space.

A pink hanging shower caddy is shown with toiletries inside. Multiple views illustrate its portability, including a clear phone pocket and a person using it in a bathroom. It's designed for organizing personal care items.

A set of pink heavy-duty storage bags with carrying handles and backpack straps. One bag is open, filled with clothes, while others are stacked. A person demonstrates carrying the bags, highlighting their use for moving and storage.

College dorm essentials that I actually needed!

After finishing my freshman yr of college this is all things I wish I had bought that know one never told that I would need for my college form! #dormhaul #dormchecklist #dormaesthetic #dormnecessities #dormstyle Arizona State University Tempe Campus

681 likes

Build a Content Calendar in Less than 30 sec!

Comment ‘CONTENT’ to access 365+ Content Ideas & AI Prompts just for you!👇🏽 Plan out next months content now! ⁠ 👉🏽 Do you want to save time creating Reels for your business?⁠ ⁠ 👉🏽 Do you wish you had clarity and a roadmap on what Reels to post?⁠ ⁠ 👉🏽 Have you ever wasted hours scrollin

253 likes

How To Avoid Information Overload in College :(

College can feel like constant input; lectures, assignments, emails, study guides, and all the random info you’re supposed to keep track of. When everything feels important, it’s easy to freeze or burn out. One thing that helped me was learning to filter. Not everything needs to be handled right aw

349 likes

A laptop displaying a digital calendar and task manager, with a monitor showing a January 2024 calendar in the background. The image highlights tips for a digital detox to create a beloved digital life.

Text on a light background titled '1. Give your desktop or laptop a make-over,' listing tips like arranging icons, cleaning the taskbar, creating folders, updating software, and managing bookmarks.

Text on a light background titled '2. Clear and organize emails,' providing advice to have an organized email inbox and delete unread newsletters and social media updates.

Tips for Digital detox for Digital Life You Love

So here's to a clutter-free digital life and a balance that keeps us sane and focused! 🌟 First off, it's cleanup time! Delete those unnecessary files, bid farewell to space-hogging photos and programs. Oh, and don't forget to empty that recycle bin tidy up your desktop – arrange t

70 likes

⚡️ My Favorite ChatGPT Prompts That Save Me HOURS

✨ Copy + paste these, and thank me later: ⸻ 1️⃣ Content Calendar Builder 👉 “Create a 30-day content calendar for [business type/niche], with daily post ideas, captions, and suggested hashtags. Make it engaging, audience-focused, and formatted as a table.” ⸻ 2️⃣ Caption in My Brand Vo

24 likes

A young woman with long dark hair and light eyes smiles at the camera, wearing an orange ribbed turtleneck and a gold chain necklace.

A laptop screen displays a list of university courses on Canvas, with an overlay text advising to pick enjoyable electives to boost GPA.

A hand holds a closed MacBook with a light-colored textured skin, accompanied by text advising to use office hours and stay on top of due dates.

How I Saved My GPA (and My Sanity 😮‍💨)

I won’t lie, my GPA was looking rough at one point. I thought I’d completely ruined my chances, but it wasn’t over. What helped me turn it around was being super intentional with my class choices. I picked electives and gen eds I knew I could handle! Not to take the easy way out, but to rebuild my

17 likes

What Version Of You Is Walking into Q2

Most people close Q1 by flipping the calendar. High performers close it by sitting down and getting honest. Reflection without documentation is just a feeling. And feelings fade. What you write down becomes a system — and your Q2 system starts with what Q1 actually taught you. This week, befo

1 like

Olaf just wandering off at Disneyland Paris at the New World of Frozen coming next March! Beyond cute #disneyland #WorldOfFrozen #frozen #disneyadventureworld #disneylandparis

60 likes

study with me for med surg!

🩺Med surg has not be an easy class! This is how I’ve been studying. I definitely don’t have the highest grades but I’m getting through the best I can! I was very happy with my score and I studied hard. I love using Quizlet because I can study almost anywhere. When I’m standing in line at the st

370 likes

Replying to @Jaycee babygirl #greenscreenvideo Updated video on how to catch him with a Facebook Data Download 😘 #retiredpsycho #relationships #toxictok #howtocatchacheater

580 likes

Hidden Study Tools That Changed Everything

1. ExplainThis.io 🧠 ExplainThis.io is an AI-powered tool that breaks down complex info into clear, simple explanations. Whether it’s a confusing article, a technical topic, or something you just don’t get, this tool turns it into beginner-friendly content perfect for studying or quick learning.

135 likes

The Smart Way to Play: World 05 Tropical Tidal Wav

Protect your investment, play with the best. I’m all about keeping my RL cards in the vault, but I still want that authentic feel on the table. This double-sleeved beauty is 1:1 black core with a perfect matte finish. The print quality is so sharp, your opponent won't even blink. It’s the ultim

1 like

#opportunity #missed #big #glorilla #sister

0 likes

HOW TO SURVIVE IN NURSING SCHOOL.

#communitycollege #nursingstudent #nursingschool #nursesoflemon8 #prenursingstudent

8 likes

My “everything” shower🚿🧼🛀

This is a in depth but not so in depth routine! It’s hard as hell to record solo in the shower 🤣 and I do not have time to record on my free time! Hoping for better content as I upgrade my equipment:) Anyone else use the same products? Do you love them? Step 1: Bath and Body Works: Gingham Fr

37 likes

A title slide for 'Content Ideas Brain Dump' featuring '2 Months Of Lemon8 Content' overlaid on a table template for ideas, type, and platform.

A content ideas table for 'Lifestyle' topics, including morning/night routine, weekly reset, productivity hacks, space organization, a day in the life, vision board, budgeting, self-care, current faves, and BTS.

A content ideas table for 'Fashion & Beauty' topics, including OOTD breakdown, capsule wardrobe, thrift finds, skincare, makeup tutorial, haircare, beauty dupes, accessorizing, seasonal look-book, and closet organization.

✨SAVE THESE FOR LATER: 50 Content Ideas For 2025🍋✨

Feeling stuck on what to post? Here are 50 content ideas (2 1/2 months- excluding weekends!) to get you back on track! 🍋 Whether you’re a lifestyle creator, fashion enthusiast, foodie, or wellness advocate, there’s something here for everyone. 💡 The key to consistent content creation? Planning a

36 likes

An overhead view of various skincare products arranged on a white shelf, including cleansers, toners, and moisturizers. The image features text overlayed with 'SKINCARE ROUTINE for sensitive and acne-prone skin' and 'SWIPE', indicating a multi-step guide.

A hand holds a white tube of a low pH gel cleanser over a white sink. The product is described as a favorite for leaving skin soft after cleansing.

Two toner bottles are displayed on a desk. One is a large white bottle of hydrating milky toner, and the other is a smaller white bottle of PHA toner, suitable for exfoliation or oily/combination skin.

Glass Skin Routine for CHEAP!

It looks like a lot (and feels like a lot) but it’s all part of the process baby. Good skin takes effort! The most important part of a glass skin routine: DRINK YA DAMN WATER Y’ALL 😂 DISCLAIMERS: • I know some of these products are NOT cheap. I listed the prices you see in Ulta/Amazon, but I

64 likes

Like please & bye 😂😂😂 idgaf on my soul!!! #unbothered #toxic #family #irisayaba

2 likes

👇3 of the biggest lessons I learned this year👇

🫡Consistency in work and in training I have been posting on social media since 2020, but this was the first year I truly felt like I gave it my all. I had wins and I had some big flops, but I did not let the numbers slow me down. I kept showing up and putting myself out there anyway. With a lot

12 likes

Binder Goals: The Smart Way to Collect 📸

Why risk damaging a $10,000 grail during a game? This Tropical Tidal Wave is the ultimate placeholder. High-end printing, authentic snap, and looks flawless double-sleeved. Keep the investment in the vault, keep the fun on the table. #CollectorLife #PokemonStyle #BinderEnvy #TCG #SmartS

0 likes

Score cheap tickets to Wicked on Broadway

Wicked is one of the most popular shows on Broadway, so tickets can be hard to come by! Thankfully they have a couple of great ways to get great seats at affordable prices! 1️⃣ If you are a student, you can purchase tickets for $69 at the box office. Unlike a lot of student discounts, these ar

9 likes

College DITL with no practice

#offday #schoolwork

13 likes

🍠 The BEST Candied Yams Recipe 🍠

INGREDIENTS: 🍠 2 lbs Sweet Potato (Orange preferably but White works too) 🍠 3/4 cups Light Brown Sugar 🍠 1 cup White Sugar 🍠 2 teaspoons Cinnamon 🍠 1 teaspoon Nutmeg 🍠 1/4 teaspoon Ginger 🍠 1/4 teaspoon Salt 🍠 2 tablespoon Vanilla Extract 🍠 1 Stick of Butter 🍠 4 tablespoons Frroz

150 likes

This image announces the Pokémon Go Adventure Week event, featuring Toedscool, Toedscruel, and the Shiny debut of Wiglett. The event runs from July 29 to August 3, local time, showcasing these featured Pokémon.

This image details Pokémon Go event bonuses, including Toedscool's evolution, 2x XP, 2x Catch XP, and 2-hour Incense. It also outlines rewards for Timed Research and Paid Timed Research, which includes Lucky Eggs, Rare Candy, and event-themed Pokémon encounters.

This image lists wild Pokémon encounters during the event, categorized by habitat: Cities, Forests, Mountains, and Beaches & Water. It highlights Pokémon like Snubbull, Toedscool, Hippopotas, and Wiglett, noting that some can be encountered as Shiny, with Wiglett making its Shiny debut.

Shiny wiglett debut

Shiny wigglett debut and toadscool During adventure week in game #pokemo n #pokemongo #fyp

6 likes

No dogs were harmed (excluding my feet).

We can gloss over that horrific storm last night. Just forget about all that hail damage. & the flooding. Fagetaboutit.

53 likes

More detailed explanation below:

Tech professionals recommend regularly restarting your computer to enhance system performance by clearing out clogged RAM and background processes, apply critical software/security updates, and fix glitches, bugs, or hardware conflicts. A weekly reboot is generally advised to keep systems running e

1 like

1 like

Biolage as a cosmo student

Highly recommend the Biolage line 💆🏾‍♀️ They have so many options to choose from such as: 1. hydrasource for hydration 2. Strength recovery for split ends and breakage 3. Bond Therapy for over processed hair 4. Purple shampoo and conditioner 5. Hair masks 6. Scalp therapy for dry hair

116 likes

#exercisetraining Bruce Leeroy and his Nephew polishing up our Exercise training technique for the good of Humanity ☯️💪🙏

4 likes

An HP iPAQ Pocket PC displaying a calendar and task list for July 1, 2003, showing appointments, events, and tasks. The image highlights how Pocket PCs in the 2000s helped manage schedules and productivity.

An HP iPAQ Pocket PC showing its 'Start' menu with options like Calendar, Contacts, Inbox, and Pocket Word/Excel. Text describes the Pocket PC 2000 as a portable device for managing schedules, contacts, and tasks, supporting Microsoft Office applications and wireless connectivity.

A Windows XP Tablet PC with a stylus resting on its screen. Text explains the 2002 Windows XP Tablet PC Edition featured a pen-based interface for handwritten notes and included pre-installed Microsoft Office applications like Word, Excel, PowerPoint, and Outlook.

Productivity in the 2000s:📱📊⏳

⫘⫘⫘⫘⫘✌🏾🩵🤙🏾⫘⫘⫘⫘⫘ Throughout the 2000s, technology evolved rapidly to enhance productivity planning, beginning with the Pocket PC in 2000, which allowed users to organize tasks and access applications on portable devices. The introduction of Windows XP Tablet in 2002 and the Palm Treo 650 in 2

377 likes

A person with brown mini twists, featuring a lighter auburn pop of color at the ends, is shown from behind in a car. The image highlights the 'FALL HAIRSTYLE mini twists benefits and tips' with autumn-themed decorations.

The same person with mini twists is shown from behind in a car. Text overlays indicate the 'DURATION: 2-3 hours' for installation and provide 'TIPS' for maintenance, including deep conditioning, detangling, moisturizing, and oiling the scalp.

A person with brown mini twists is shown from behind in a car. The image lists the 'BENEFITS' of mini twists, such as being versatile, easy to style, low tension, moisture-retaining, long-lasting, and a protective hairstyle. It also prompts to 'SAVE THIS POST FOR LATER!'.

Fall hairstyles inspo!!🍂🍁

Mini twists are a low maintenance low tension hairstyle that you can style many ways making it so versatile and beneficial and fun to style daily. it's easy to maintain and perfect for any season I love it for the fall though because of my pop of color but my hair is brown and I love how my dif

278 likes

Level up your career in 2026 ✨

Hey there! 👋 I’m a Senior Recruiter with 5+ years of experience placing professionals with Fortune 500 companies — so I know exactly what makes a hiring manager stop and pay attention. 👀 I turned that insight into clean, effective resume templates you can start using today to stand out in a comp

10 likes

A person holds a dumbbell in a gym, with text overlaying "Weird operating rules that defend my team from task overload (Yes, your team will literally kiss you for these too)". The image introduces productivity hacks.

Text on a plant background describes rule 4: "Tell us what's blocking you Every Monday: each person shares what's blocking them, not what they're working on. Progress updates are BAU. Blockers are what actually need to handle".

A laptop on a desk with a city skyline at sunset. Text explains rule 3: "The Honest Estimate Rule Every estimate includes a second number: how long it would take if two unexpected things went wrong.".

How I Defend my team from task overload 😤

#productivityhacks #productivitytips #productivity #adhdhacks #adhdtips

1 like

3 Easy Investments to Make

Investing can be overwhelming and complicated, but ETFs (Exchange-Traded Funds) are a great and simple way to invest. These funds allow you exposure to a variety of stocks instead of individually choosing them (which can be more risky if you don't have the knowledge/time to handpick them).

44 likes

You are doing it wrong, here’s how to do it! Read⬇️

It's a complete content system designed to help you create and plan quality content faster. Designed for everyone who wants to streamline their content creation. Whether you're new to content creation or have been in the field for a while, the Ultimate Content System will help make content

22 likes

✨️Day 1️⃣ of 🔟 Days of🌌Galactic🧬Activation🪞Portals

Tuesday's Oracle (Jul 08, 2025) 🤍White🌔Lunar🌐Worldbridger🌉 🤔Today's Question: "What is my challenge?"☆ "🌌Galactic🧬Activation🪞Portal🔘Day☆These are special inter-dimensional days when other dimensions 'open up' and are more easily accessible. These are generally high e

1 like

Fav Stationary Supplies

#lemon8challenge #stationerylover #stationary #stationaryaesthetic #supplies #stationeryrecommendation

4 likes

Link in bio. Take control of your spiritual Business.💕 #spiritualbusiness #spiritualbusinesscoach #manifestationcoach #manifestationcoaching #businesscoach

0 likes

Why you should get the Amex platinum and what all the benefits are!!! In my opinion definitely worth it. You’re basically making money back. #amexplatinum #amex #amexbenefits Hotel credit: up to US$600/year, given as two semi-annual credits of up to $300 each on prepaid bookings through Fine

3 likes

A person takes a mirror selfie in a restroom, with text overlay 'Budget with me as a pizza hut employee', indicating the start of a budgeting journey.

A person in a car, wearing a cap, with text overlay 'step 1: go to work!', signifying the beginning of their work day.

A screenshot displays a biweekly pay estimate of $1,299.20, including credit card tips and income tax, along with scheduled work hours for a Pizza Hut employee.

Budget with me as a pizza hut employee!

Budgeting in the current U.S. economy is very challenging especially as an 18-year-old with no support from family or friends. With inflation driving up the cost of essential goods like food, housing, and transportation, managing limited income becomes a significant struggle. Entry-level jobs, whic

641 likes

Cool Off with a $1 Big Gulp at 7-Eleven! 🥤🔥 #stressfreeinc Cool Off with a $1 Big Gulp at 7-Eleven! 🥤🔥 $1 Large Big Gulp Offer Expires 08/26/2025 Summer is here, and it’s the perfect time to cool off with a deal from 7-Eleven! Right now, you can get a Large Big Gulp for just $1.00 (re

1 like

See more