Automatically translated.View original post

28.5K followers

Follow

Follow

Follow

52 saved

63

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

3492 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

254 likes

Let’s use those paper Qs!

Dollar General deal valid 7/19/25!! #dollargeneralcouponing #dollargeneral #couponingwithcollie #fyp

967 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

4610 likes

How I Automate My Content ⚙️

3 Digital Marketing Tools I Use Daily To Automate My Content As A Business Owner 💁‍♀️ #digitalmarketingforbeginners #digitalmarketingtips #contentcreatortips #contentcreation #contentstrategy

45 likes

FREE NOTION TEMPLATE 🧸🥛🎀

Aesthetic and Productive Notion template sharing for free - Study Notes - Study schedule - Notion AI - Projects and tasks - Assignment and exam Check it out at the 🔗 in my bio #studytok #study #notion #notiontemplate #notionAI #NotionPartner #productivity #studentlife

830 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

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

625 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

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

744 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

368 likes

A tablet on a desk displays the Goblin.tools 'Magic ToDo' interface, showing a task list. The image is titled 'Study Tools I Use But Never Talk About' and features a clean study setup with a keyboard and stationery.

A laptop screen shows the ExplainThis.io website, highlighting features like 'Levels Up Your Tech Career,' 'Interview Preps,' 'Resume Tips,' and 'Career Insights,' with articles on tech concepts.

A laptop screen displays various Goblin.tools features: 'Magic ToDo' for breaking down tasks, 'Formalizer' for adjusting text tone, 'The Judge' for decision analysis, and 'The Chef' for recipe ideas.

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.

138 likes

A resume template for Jonathan Brooks, an early-career tech professional, with sections for summary, work experience, education, skills, and certificates. The text "Get Hired by Top Companies!" is overlaid in orange.

A resume template for Sarah Morgan, a customer service representative, detailing her professional summary, education, work experience, and skills. The text "Stand out Get Hired!" is overlaid in orange.

A resume template for Ethan Rodriguez, a finance and accounting executive, showcasing his professional summary, work experience, skills, and educational background. The text "Easy to edit!" is overlaid in orange.

Resume Templates - Hired by Top Companies ✅

With over 5 years of experience recruiting for global companies like BMS, Merck, Amazon, Johnson&Johnson, Stryker, Northrop - I’ve reviewed thousands of resumes and helped hundreds of professionals land interviews at Fortune 500 companies. I’ve learned what hiring managers like and what gets

155 likes

You think you have a consistency problem?

You’re not inconsistent. You just don’t have a system that’s built from the way you actually move. Most people call it “lack of discipline” when what’s really happening is this: they’re trying to live inside someone else’s operating pattern. New planner. New content calendar. New morning rout

5 likes

US TRAVEL | 4 day road trip in Washington

🛫 Flying to/from Seattle–Tacoma International Airport , excluding the day of arrival. 📅 Day 1: 📍 Olympic National Park : Head straight to the coast and visit all the beaches. 📍 Forks: Stop here. 📍 Hoh Rain Forest : Drive directly from Forks to Hoh Rain Forest. The drive should tak

43 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

148 likes

A vibrant sunset over the SeaGlass Carousel in Battery Park, New York City, with the title "Mermaid lovers guide to New York City" overlaid. The carousel building is illuminated, surrounded by trees and a path.

The interior of the SeaGlass Carousel, showcasing its unique, colorful fish-shaped rides. The text describes it as a beautiful, under-the-sea modern carousel in Battery Park, costing $6.

A person stands in the illuminated shark tank tunnel at the New York Aquarium, pointing upwards at a large ray swimming overhead. The text highlights it as the oldest continuously operating aquarium, with tickets costing $25-32.

Mermaid Things to do in NYC

Do you love mermaids? Under the sea theme? Or just whimsical things? Next time you travel to NYC, save these mermaid inspired spots in New York ! SeaGlass Carousel This whimsical carousel sits in Battery Park where the NY Aquarium used to be housed before it moved to Coney Island. This

346 likes

College DITL with no practice

#offday #schoolwork

13 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

A ChatGPT cheat sheet by Calvin Klein Reyes, detailing prompting techniques, roles, tasks, formats, writing styles, plugins, marketing prompts, tools, role-playing, prompt ideas, jailbreak prompts, and tips for effective prompting.

A ChatGPT prompting cheat sheet outlining modes, roles, formats, tones, chain prompt examples, and specific prompts for marketers, coders, sales, designers, research, customer service, and general use, along with top prompting tools.

A ChatGPT 'Zero to Power User' cheat sheet defining key terms, use cases, prompt frameworks, tones, formats, miscellaneous tips, modes, other chatbots, example prompts, and useful plugins for advanced prompting.

Chatgpt cheatsheet 1/10: one page equals a book

I've recently curated and tested several high-quality cheat sheets, each packed with a plethora of useful prompts and techniques that are easy to look up and remember. Leveraging these prompts can lead to efficient and top-notch creations for users across various industries and needs. #chatgp

74 likes

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

72 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

279 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.

70 likes

Why do we feel so guilty for making time for ourselves? The kids need more of us, the spouse wants more intimacy, your friends miss the fun version of you, and you just feel so guilty to pour even an ounce into yourself. I resonate with that having a son (soon to be two sons and a wife who N

77 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

Places to Travel For Cheap ~ Must Go Destination

Remember these are average costs and can vary depending on the specific location, time of year, and level of comfort or luxury you prefer. Additionally, prices may be higher in popular tourist destinations compared to smaller towns or rural areas. It's always a good idea to research and com

58 likes

My Top College Tips !

With a new semester about to begin, I wanted to share some college tips for those just starting their journey or struggling a bit! 🎓📚 ✨Take a Light Course Load If you’re new or get overwhelmed easily, start with a light course load. College is different from high school. Don’t overwork yourse

68 likes

smells amazing 🍨 it’s world mental health day 💐 from oct 10–12, sephora will donate 100% of rare beauty fine fragrance sales (excluding find comfort products) up to $500,000 to the rare impact fund 🤍 so grateful to be part of something that gives back

65 likes

A green Twemco flip clock on a black shelf, displaying 'WED 18 JUN' and an analog clock face. It is decorated with small green figures and plants, with books like 'CELINE' and 'VOGUE' stacked above.

A wall display of various Twemco clocks, including flip clocks and analog clocks, showing different times and dates like 'SAT 10 MAY' and 'HONG KONG 3 14'.

An open brochure on a glass table, showcasing different Twemco clock models (wall & table clocks, drum shape table clock) with specifications and available colors like white, black, and orange.

twemco clock from hong kong ⏱️

i saw this on tiktok some time last year and i knew i HAD to get this the next time i went to hong kong so that’s exactly what i did def on the pricey side at ~$172 USD but this is such a cool souvenir, especially with the chinese characters since both me and my husband are cantonese 🥹 i chos

2 likes

3 Respiratory Medications Every Nursing Student Must Know Before the NCLEX 💨📚

🍋 Caption: If you’re studying for the NCLEX, these 3 respiratory medications should be at the top of your pharmacology review list: ✅ Albuterol • Rescue inhaler • Used for acute asthma attacks • Side effects: tachycardia, tremors, palpitations ✅ Fluticasone • Inhaled corticosteroid •

10 likes

IM WRITING A BOOK!

I have already written and published 4 books (if you didnt already know) but all throughout the summer I have been plotting my fifth! I do plan to self publish again. Its a romance novel that spans an entire year but starts in the springtime. I am so attached to these characters and I love them li

223 likes

20 Most Confused Finance Topics

Here are the 20 Most Confused Finance Topics you shouldn't confuse. -------- 1. Cash Flow vs. Profit - Profit can exist on paper due to non-cash expenses like depreciation, cash flow links to the actual cash on hand. 2. Assets vs. Liabilities - Assets add value; liabilities represe

269 likes

Breaking Down the 509 Report (aka Your Law School Cheat Sheet) Let’s talk about the document nobody tells you about - the 509 report. This is where you’ll find median LSAT scores, percentile ranges, scholarship breakdowns, whether scholarships are conditional, and tuition costs per year. Star

1 like

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

A resume template for 'JONATHAN BROOKS' with sections for summary, work experience, education, skills, and certificates. An overlay reads 'Ready to land your dream job?'.

A resume template for 'SARAH MORGAN' featuring sections for professional summary, education, work experience, and skills, highlighting customer service and administrative roles.

A resume template for 'STEVEN MILLER' showcasing sections for professional summary, work experience, education, and core competencies, detailing executive and engineering roles.

These resume templates worked 📝✨

With over 5 years of experience in recruitment and working alongside countless hiring managers, I’ve seen what works and what doesn’t. These templates are designed to save you time, look clean and polished, and make your experience easy to read ✨ There are countless styles to choose from - so

50 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

Fav Stationary Supplies

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

4 likes

See more