Automatically translated.View original post

28.4K followers

Follow

Follow

Follow

10 saved

12

(1 / 2) How many weeks does this work take? How many days?

How to find the number of days by getting answers in weeks. This clip has 2 clips in total. This clip is clip 1 😎💚# excelsoezy # Excel # Exceltricks # exceltips # Lemon 8 Howtoo

4/16 Edited to

การคำนวณระยะเวลาเป็นสัปดาห์และวันใน Excel ทำให้เราสามารถวางแผนการทำงานได้ดีขึ้นและตรวจสอบเวลาที่ใช้กับโปรเจกต์ต่างๆ ได้อย่างแม่นยำขึ้น โดยทั่วไปแล้ว เราจะเริ่มจากการใช้ฟังก์ชัน DAYS เพื่อหาจำนวนวันทั้งหมดระหว่างวันที่เริ่มและวันที่สิ้นสุดงาน จากนั้นใช้ฟังก์ชัน INT เพื่อคำนวณจำนวนสัปดาห์โดยหารจำนวนวันทั้งหมดด้วย 7 แล้วดึงเฉพาะเลขจำนวนเต็มมาใช้ ส่วนวันเศษที่เหลือจะคิดโดยการนำจำนวนวันทั้งหมดลบกับจำนวนวันที่ได้จากการคูณสัปดาห์เต็มด้วย 7 ขั้นตอนสุดท้ายคือการรวมค่าที่ได้ทั้งสัปดาห์และวันเศษให้ออกมาในรูปแบบข้อความที่เข้าใจง่าย เช่น "3 สัปดาห์ 2 วัน" ซึ่งเหมาะสำหรับนำไปใช้รายงานหรือติดตามงาน ในชีวิตจริง การรู้วิธีใช้สูตรเหล่านี้ช่วยให้เราไม่ต้องนับวันด้วยมือหรือใช้วิธีคำนวณแบบไม่เป็นระบบ ทำให้ประหยัดเวลา เพิ่มความแม่นยำ และลดความผิดพลาดในการวางแผนจัดการเวลางาน นอกจากนี้ยังสามารถปรับใช้ในสถานการณ์อื่นๆ เช่น การคำนวณเวลารักษา การติดตามการฟื้นฟู หรือการวางแผนกิจกรรมต่างๆ ได้อย่างสะดวกสบาย

Related posts

A 'before and after' image showing a woman's body transformation, labeled 'Summer 8 week challenge Before Now', against a tropical leaf background. The 'before' shows a fuller figure, while the 'now' shows a more toned physique.

A yellow background with watermelon slices features a 'Summer Countdown' calendar showing 'GET READY 70 MORE DAYS'. The text 'Loading...' and 'SWIPE' are also visible.

A 'Workout Plan Day 1 - Glutes' on a yellow background with watermelon slices. It details exercises like Cable Kickbacks, RDL, Hip Thrust, Glute Extensions, and Glute Bridges with sets and reps.

Start Today for Results in 8 Weeks | FREE GUIDE 🍋

Get Ready for Summer with my FREE Fitness Challenge Guide! ☀️🌊 With summer just around the corner, it's time to get ready to feel your best as we head into those sunny days and outdoor adventures. If you've been looking for a way to jumpstart your fitness journey and see some real results

59.5K likes

How Long Does Skincare Really Take to Work?

Wondering how long skincare takes to work? ⏳ As a licensed esthetician, I get this question all the time! Every product has its own timeline — cleansers and moisturizers can give instant results, while ingredients like retinol, niacinamide, and vitamin C can take weeks to show changes. If you’ve

542 likes

A young woman holds colorful notebooks and a shopping bag, with text overlayed stating "Free Courses To Boost Your Resume," illustrating the article's theme of enhancing skills.

A graduate celebrates, with overlaid text boxes detailing two free online courses: "CS50's Introduction to Artificial Intelligence with Python" and "Nonprofit Financial Stewardship Webinar."

A graduate smiles, with overlaid text boxes presenting two free online courses from Stanford: "Principles of Economics" and "Databases: Relational Databases and SQL."

Free Courses to Take to Boost Your Resume

If you are looking to up your resume, there are many ways to do so from course work to freelancing to volunteering. But, if you want to learn some new skills - here are some free courses to take! Harvard - CS50's Introduction to Artificial Intelligence with Python Harvard - Nonprofit Financ

5099 likes

REAL glow up tips that ACTUALLY work !

i stand by these… everyone puts things like “get sleep” “wake up early” and those are absolutely ways to better yourself and create a working routine but we are talking about GLOW UPS. these products work and i’ll tell you why: ✨grande lash serum: this stuff made my lashes look amazing after like

1510 likes

A woman stands on an intricate wooden walkway overlooking a landscape at sunset, with text overlay "2 weeks in Mexico under $700" highlighting budget travel tips for Mexico.

A vibrant blue ocean with a cloudy sky, featuring text overlay "Cancun 4 Days $130-$180 Recommendations" and pink boxes listing Playa Langosta, Cenote La Noria, Xcaret, and Xenses Park.

A thatched-roof hut on a beach with waves, featuring text overlay "Playa Del Carmen 4 Days $180-$250 Recommendations" and pink boxes listing Playa Maroma, Fundadores Park, Cenote Chaak Tun, and Snorkeling.

2 weeks in Mexico on a budget

If you’re traveling to Mexico here are my tips and recommendations on how to travel this beautiful country on a budget. Cancún To save money while in Cancun I recommend taking the local bus since it takes you everywhere and each ticket costs 💰Price:$0.66 and instead of fancy restaurants go

3093 likes

How Many Signs Does Your Partner Have?

How Many Signs Does Your Partner Have? He is kind and sweet He is not afraid to say he’s sorry You feel secure and comfortable when you’re around him You both communicate openly and honestly with each other He supports your dreams He always makes time for you no matter how busy h

907 likes

What is the 5-second rule and why does it work? ⏱️

The 5-second rule, popularized by Mel Robbins, is a productivity strategy that encourages immediate action. When you have an impulse to do something, you count down from five and take action before hesitation and self-doubt set in. It helps overcome procrastination, builds momentum, engages the dec

201 likes

A fan of twenty-dollar bills is spread on a pink, textured surface. Overlaid text in pink reads "Money Saving Tips" and "HOW I SAVED OVER 1000$ in 8 WEEKS," accompanied by a pink smiley face heart icon, illustrating the article's financial advice.

HOW I SAVED 1k IN 8 WEEKS

how i saved over 1,000$ in 8 weeks (easier than you think) first things first recognize your salary, how can you split up your paycheck while having financial freedom? •for me personally i’m a server so i get “paid” daily or whatever days i work. i started by saving all my 1 and 5 dollar bills

172 likes

Feel & Look 🔥HOT🔥 By Summer: (It’s 4 Weeks Away)👙☀️

Example 4-Week ✨Weight lifting/ Gym✨ Plan Weekly Structure: Day 1: Glutes + Cardio Day 2: Upper Body + Cardio Day 3: Legs + Cardio Day 4: Upper Body + Cardio Day 5: Glutes + Cardio Day 6: Cardio/Running/HIIT Day 7: Active Recovery Repeat every week, repeated every month ❤️ ———————

1344 likes

Mommy to be💙🥰How many weeks Are you?

34 weeks 5days 🥹 we almost there guys!!! #pregnant🤰 #firsttimdmom

238 likes

How many of these games have you tried? 👇

Was going through Roblox’s game chart and found this week’s Top Trending Games, Here they are! 1.) Restaurant Tycoon 3🧑‍🍳- In this game your tycoon can be the next fancy restaurant, trendy cafe, or something else completely up to your imagination. You can cook, serve, and build your way to your

464 likes

Build Discipline And Take Control Daily

Nobody Cares, Work Harder, The Mindset Shift That Builds Real Discipline Some days feel heavy. Some days feel unfair. Some days feel like you are carrying everything alone. That is where this mindset becomes real. It is about taking control of your life again. It is about discipline, sel

55 likes

How I get my toddlers energy out on a rainy days 🌧️

When you can’t take your toddler outside to get their energy out, it’s real hard (at least in my case) to get my daughter ready calm and ready for bed! 😩 I found this channel a couple months ago and wanted to share! It’s called the kiboomers on YouTube and it has so many fun activity videos for

603 likes

A study desk with a tablet displaying notes, an open textbook on benzodiazepines, a burrito, and an iced coffee, overlaid with the text '50 POINT SCORE INCREASE IN 3 WEEKS'.

A study plan for Week 1, outlining steps like choosing 1-3 sources, writing detailed topics, adding color and pictures, understanding content, and focusing on quality over quantity.

A Week 2 study plan featuring reviewing comprehensive notes, watching short videos (Lecturio & Osmosis), and utilizing practice questions, shown with headphones and glasses.

BUMP your GPA in 3 weeks!!!

Recently, I took my End of Rotation PAEA in psychiatry! My prior test scores in other rotations had all been below average, and I was feeling pretty beat down. That’s when I decided to completely revamp my study methods!! I narrowed down the number of sources I was using, stopped ingesting co

27 likes

i tested way too many lash serums so you don’t waste your money!! 

#lashes #beautyfinds #amazonfinds #lashgrowth #eyelashes

0 likes

How many 🐈 does it take to screw in a💡

New to Lemon8! #cat #cats #feline #felines #funny #lol #voiceover #voiceovers #dustydubs #animalvoiceover

186 likes

The front cover of 'The Bible in 52 Weeks: A Yearlong Bible Study for Women' by Dr. Kimberly D. Moore, held by a hand with blue nail polish. Overlays include 'A Look Into', '364 days', and 'Spend one hour learning Gods word each day'.

The back cover of 'The Bible in 52 Weeks' describing its interactive journey, practical features, and author Dr. Kimberly D. Moore. It lists the price and ISBN. An overlay reads 'CREATE A ROUTINE WITH GOD'.

The Table of Contents for 'The Bible in 52 Weeks', displaying weekly topics from Week 1 to Week 40, such as 'There's Nothing Too Hard for God!' and 'Thank God for the Crushing'.

A Look Into The Bible in 52 Weeks 📚💕

First of all, I love this book not only because it breaks down each story so simply, but it also gives you journal prompts to reflect on! Sometimes it can be hard to think of prompts to help you reflect on what you’ve just learned, but this book makes it so easy for me to actually WANT to follo

125 likes

A hand displays long nails, with one nail showing significant swelling, separation, and flaring at the tip, illustrating the effects of water absorption. The image compares water versus acetone and highlights how water causes swelling, separation, and flare in nails.

Text on a light background explains that nails are layered, not solid, composed of keratin, lipids, and protein bonds, and that water disrupts this structure.

Text on a light background states that nails absorb water, capable of absorbing up to 30-35% of their weight, emphasizing its significance.

What Water Really Does to Nails💧👀

Most people are taught to fear acetone. Very few people are taught how water actually affects nails. Nails are made of thin layers of keratin held together by lipids and protein bonds. They are not solid. They are porous, which means they absorb moisture from their environment. That porosity

1170 likes

Does anyone else have horrible in-laws?

My in-laws treat me like crap. The 19 year old and I have been close for five years and all a sudden she is too busy now. And says she does not have to explain anything to me. She has always messaged me for advice and help and just to talk. So when I message her to check on her she will leave me

1138 likes

A chart titled 'How Long Does It Take To Work?' details the timeframes for various skincare ingredients to treat specific skin conditions. It lists ingredients like Retinol, Vitamin C, AHA, BHA, Hyaluronic Acid, and Niacinamide, showing how long each takes to address concerns such as acne, hyperpigmentation, fine lines, wrinkles, skin hydration, and redness.

How long does it take to work ? Skincare edition

People use skincare products to keep their skin healthy and looking good. These products help to moisturize the skin, protect it from the sun, and prevent acne and other skin issues. They can also help to reduce signs of aging and improve overall skin texture and appearance. Follow @Lemon8 Beauty

20 likes

An overhead shot of three skincare serums, including a retinol, a vitamin C, and an HA/BHA product, with the question 'How Long Does It Take To See Results?' overlaid.

A hand holding a blue bottle of retinol serum, with text indicating that results may take 4-12 weeks.

A hand holding a white bottle of vitamin C brightening serum, with text indicating that results may also take 4-12 weeks.

How long does it actually take to see results??😅👀

Who else uses their skincare and wonders if it’s actually doing anything?? I always like to use different products and try new things but I always end up getting discouraged. I always think a product will do my skin wonders on the first few days. Apparently each product takes a certain amount of

13 likes

Hitting big PR’s nine weeks post C-section

How I hit a 145 lb squat 9 weeks postpartum (C-section) and PR’d shoulder press at 40 lbs: 1. Jumping in works too – While many start slow postpartum, I was able to jump in quickly and lift heavy. Everyone’s body is different—listen to yours. 2. Consistency > intensity – Hitt

4 likes

you’re using too many skincare products

having a SUPER complicated skincare routine is so unnecessary and could ruin your skin! your skincare routine could be having the reverse effect you’re wanting! you don’t need a complicated, expensive, high end routine to have beautiful clear skin. utilizing a more simple routine will let your skin

160 likes

The title slide for 'I Got Shredded in 60 Days Part II,' detailing how to maintain fat loss, preserve muscle, and continue progress without regaining weight, set against a minimalist background with plants and a water bottle.

A list of common challenges during a 60-day fitness challenge, including cravings, weight regain, hunger, motivation dips, plateaus, overtraining, and social conflicts, noting these are normal and manageable.

Strategies for handling hunger and cravings, such as eating high-protein/high-volume foods, pre-planning snacks, drinking water, mindful eating, volume eating, and timing hacks.

I Got Shredded in 60 Days — Part II 🍋🤍🫶

Most people can lose weight fast… but almost nobody can keep it off without gaining it back or hitting a plateau. This post shows you exactly how to stay shredded and avoid hitting plateaus. Here’s the system I use (and now you can too) to stay shredded all year without endless cardio or star

6 likes

A woman stands in a field of plants, looking to the side, with the overlaid text "HEALING FROM A C SECTION takes longer than expected." The image is desaturated, focusing on the C-section recovery message.

Healing from a c section, how long does it take??

it’s a no brainer that healing from a c section can take longer than healing from a natural delivery. (talking from experience here!) but most moms don’t realize how long it actually takes for your c section to heal. in your first 2 weeks you’re going to feel all of the pain. you’ll be clea

5 likes

How does microd0sing change your brain? 🍄🌿✨

1 like

Does Lo-Fi really help you study? 🎧

I personally love lofi music when I'm trying to focus. While lofi music can be beneficial for many people, it's essential to recognize that everyone's preferences and study habits are different. Some individuals may find other types of music or complete silence more conducive to the

48 likes

Marketing Reset ❌ Webinars: All Of May Weeks 1-4

Follow + Message “MAY” to get more info on my May 2026 “Marketing Reset” Events May Events - Pick Week 1, 2, 3, or 4: - Week 1 - (May 4-10) - 3 days M,W,F - 3hrs/day - 6-9pm Pacific - Week 2 - (May 11-17) - weekend - Sat + Sun - 1-5pm Pacific - 4hr x 2 - Week 3 - (May 18-24) - 3 days T,

1 like

How long does it take for a dog to forget its own?

Our vet behaviorist answered it this way: “A dog’s memory of its owner isn’t measured in days or weeks. It’s literally hardwired into their brain for life.” That’s why abandoned dogs go back to the same spot for years, just waiting. Why rescue dogs freak out when their new owners leave. Why your

7 likes

Glowing routine After 3 weeks

Daily Routine with a Cooling Mint Cream #CoolingRoutine #MintCare #PoreCareTips #DailySkinGlow #KoreanBeauty #HealthyBarrier #GlowingRoutine

90 likes

I’m really excited to have a place to share my journey this time around with the new baby and pregnancy. It’s been so many years but I have noticed something different about this pregnancy. I’m not nearly as worried as I was with my first. The girls will be nine years older, almost 10! It’s the e

204 likes

how i lost 12 lbs in 3 weeks - routine 🤍🦾

i started my weight loss journey last summer. i ended up GAINING WEIGHT and was at my heaviest at 150 lbs after being 110 lbs. needless to say i was wrecked about that. on october 23rd i decided to change EVERYTHING i was doing, and 3 weeks later i lost 12 lbs! it’s been 1.5 months, 40 days exactly

121 likes

UK Tourist With Valid Visa Detained for Six Weeks

WHAT HAPPENED TO KAREN NEWTON: A retired British grandmother with a valid visa. Detained for 42 days. Slept on a detention center floor for a month. Separated from her husband. Told she was “guilty by association.” Released without explanation. Her message: “Don’t go — not with Trump in char

56 likes

How many times does it take to master the frosting

As soon as I find out… I’ll let you know. Still swirling, still learning—but that’s half the fun! DIY Decoden Kits are coming soon so you can join the chaos (and the charm). Let’s learn together! Everyone who subscribes to boppipop.com will be entered into our give away! #DecodenDIY #Ka

19 likes

How many weeks of vacation do you actually get?

I’ve been thinking about this a lot lately, because in healthcare (and healthcare-adjacent roles like mine), rest almost feels like a luxury. When I worked in dentistry, time off was rare, and even when I did get a few days, I’d spend them recovering, not relaxing. Now that I work remotely in p

5 likes

How many people does it take to lift a 170lb dog?

Ah one Ah two Ah Three 😅😂🐶 #dreeandghost #canecorso #bigdog #texas #dallas

15 likes

A guide detailing how long various skincare ingredients take to show results. It lists 10 ingredients like AHAs, BHAs, Hyaluronic Acid, Niacinamide, Retinols, Vitamin C, Peptides, Azelaic Acid, and Ceramides, along with their expected timeframes and benefits for skin improvement.

How Long Does Skin Care Take To Work?

“How long does skincare really take to work?” Great question—and the answer isn’t overnight. Consistency is key! #consistentskincareroutine #Lemon8Diary #skincare #skincareingredients

32 likes

Morning Sickness Remedies That Actually Work! 🤢➡️😊

Morning Sickness Remedies That Actually Work! 🤢➡️😊 Pregnancy is full of exciting moments, but morning sickness can definitely throw a wrench in your plans! If you’re feeling queasy, nauseous, or just overall uncomfortable, you're not alone. The good news? There are plenty of remedies tha

24 likes

How many weeks are you mamas?

14x3 and I'm having another baby girl🩷 #baby #mom #newmexico #pregnant

339 likes

A woman on a red arched bridge in a park with modern skyscrapers in the background. The image highlights a '2 weeks in Vietnam under $800' travel guide.

A busy street scene in Hanoi with cyclos and motorbikes. The image details a 4-day Hanoi itinerary for an estimated $150-$200, recommending Ngoc Son Temple, Temple of Literature, Train Street, and The Note Coffee.

Stone statues displayed in a museum setting. The image outlines a 4-day Sapa trip for an estimated $130-$180, recommending Cat Cat Village, Silver Waterfall, Fansipan, and the Culture Museum.

2 Weeks In Vietnam Under $800

Vietnam is a great budget friendly destination, and here are some tips and recommendations that you should know about before visiting. Hanoi Hanoi is the capital of Vietnam and my favorite place in the country. This city is so beautiful and has an amazing vibe. There’s many things to do an

24 likes

See more