Automatically translated.View original post

るん|簡単Excel時短術

1599 followers

Follow

Follow

Follow

91 saved

30

2

You can calculate your age from your date of birth!

Other posts @ run.excel ⬅️ time saving from here

[Function]

= DATEDIF (birth date cell, TODAY (), "Y")

------------------------------------------------------

This account (@ run.excel) is

\ Don't be late for pick-up time 🏃‍♀️💨 /

🤯 can not be solved in an instant

🕔 time to go home

👩🏻‍💻 in 5 minutes

I would be happy if I could go home earlier than usual and help make time for myself 🫶

# excel # work efficiency # excel _ beginner The age Study of Wamama

2025/10/18 Edited to

私も以前、Excelで年齢計算をする際に複雑な数式で手間取っていましたが、DATEDIF関数を知ってからは作業が格段に楽になりました。生年月日のセルを指定し、TODAY()関数で現在の日付を取得、"Y"を指定するだけで年齢が簡単に算出できます。日常業務での顧客管理や従業員データの処理にとても便利で、急な依頼にもスピーディーに対応可能です。例えばお迎え時間を把握する必要があるワーキングマザーにとって、余裕のあるスケジュール管理が叶い、ストレス軽減にもつながりました。私はこの時短ワザを使って、子どもの年齢管理が正確になり、仕事と育児の両立がしやすくなったと感じています。さらに、DATEDIF以外にもExcelには多彩な関数があるため、興味があれば色々試してみると、日々の業務効率化に大いに役立ちます。

Related posts

A person holds ultrasound images of a fetus and a bouquet of red flowers. Overlay text asks, "WANT TO CHOOSE YOUR BABY'S BIRTH MONTH?" and mentions "timing conception for a desired birth month."

A person holds ultrasound images and red flowers. Overlay text asks, "WANT A SUMMER BABY?" and lists conception months (September, October, November) corresponding to birth months (June, July, August).

A person holds ultrasound images and red flowers. Overlay text asks, "WANT A FALL BABY?" and lists conception months (December, January, February) corresponding to birth months (September, October, November).

want to choose your baby’s birth month?

hello ◡̈ Planning your conception date to align with your desired birth month requires a bit of calculation. To increase your chances of having a baby in a specific month, you'll need to consider the average length of a pregnancy (38-40 weeks) and count backward from your desired birth month.

1198 likes

A smartphone in a clear case, plugged in, displays a customized home screen with various app icons and widgets. Overlay text reads "GIRLHOOD APPS I'M OBSESSED WITH," introducing the article's theme.

Screenshots of the Pinterest app show aesthetic inspiration, holiday themes, and gift ideas. Text highlights its use for romanticizing life, building dream aesthetics, and finding inspiration, creating a calming visual world.

Screenshots of the Psyfy app feature a cartoon pet in a room and a story section about finding a house. Text describes the app as comforting, making self-reflection safe, and providing a soft emotional space.

Soft Girl Apps I Can’t Live Without

these apps make my days softer, calmer, and happier 📌 Pinterest ✅Platform: iOS / Android | Paid: Free I scroll Pinterest for endless aesthetic ideas, moodboards, and inspiration for outfits, journaling, and lifestyle. It helps me visualize the soft life I want and save everything in one place

1568 likes

How To Calculate Blood Volume 🩸

Hey girls! I am in my LAST week of phlebotomy school so I’m here to share everything I have learned with you!! I am so excited to fill you all in on notes, tips and tricks, and anything to help you pass your CPT exam!! 🩸 In this little post, I have written down my notes on how to calculate bl

883 likes

A young woman smiles while holding her newborn baby, who is also smiling. The image has text overlay that reads, "My birth story As a 14 year old mom."

A newborn baby lies on a hospital blanket, wearing a white onesie with sports ball patterns, a white cap, and matching mittens. The baby's eyes are closed.

A young woman in a hospital bed, with a nasal cannula, smiles while holding her swaddled newborn baby. The baby is wrapped in a striped hospital blanket.

Birth story from a teen mom🤰🏾👩🏽‍🍼🤯

I remember it like it was yesterday. It was a Friday. January 20th 2017. I just got out of school. My teacher texted me and said she would be on the way to sit with me while we waited for my mom to get off work. My stepfather dropped me off to the hospital before going to work, we met up with my te

211 likes

Hospital polices you can say NO to during birth

1. Continuous Fetal Monitoring Fetal monitoring is done to measure the baby’s heart rate in-utero. Some hospitals still set you up with a continuous (permanent, so to speak) heart rate monitor around your belly that is attached to a computer and printer. This monitor also measures the timing and i

569 likes

A woman in athletic wear is cooking, adding seasoning to food in a pan. Text overlays include "CALORIE COUNTING 101" and a search bar asking "how can i calculate calories to meet my goals?" with options for calorie deficit, maintenance, and surplus.

A handwritten page from a notebook titled "CALORIE CALCULATOR (simplest method)" shows formulas for calculating daily calories for maintenance, a 20% deficit, and a 20% surplus, with an example for a 140 lb woman.

A graphic titled "Helpful Apps" displays icons and descriptions for "TDEE Calculator" and "MyFitnessPal." The descriptions explain how each app helps determine calorie intake, track food, and provide insights for fitness goals.

HOW TO CALCULATE CALS TO MEET YOUR SPECIFIC GOALS🙌

If you struggle calculating your recommended calories and/or understanding how to calculate what calories are required for you to be in a calorie deficit or calorie surplus, this is for you! first of all, math is not my specialty which is why i let other websites and apps take over and do the ha

1415 likes

What I wish I had last time I gave birth 🤰🏾✨

💛With my first child he came and I wasn’t prepared at all ! No bags just had to be induced right away. 💛With my second child I had bags packed but they were not with me and my fiancé had to pick me up from my moms house 💛So needless to say with this 3rd and final baby I wanted to make sure I

872 likes

My "extra" Birth Plan🌸

Yes, maybe it was a lot but guess what, the nurses didn't have to ask me a single thing. Everything was there, pre thought about, and I didn't have to stress about any decision making because all of my decisions were made and available. The nurses were also super sweet about it and loved th

478 likes

How to Calculate Your Macros (Based on BMR)

So you’ve got your BMR… now what? 👇 Here’s how to turn it into a full macro breakdown for fat loss, maintenance, or muscle gain: 🔹 STEP 1: Calculate TDEE Multiply your BMR by your activity level: Sedentary: BMR × 1.2 Lightly active: × 1.375 Moderate (3–5x/week): × 1.55 Very active

25 likes

The image provides instructions on "How to Calculate Your Tarot Birth Cards" using "Method 2 - Calculating Two Birth Cards." It explains a numerical process involving adding birth date components, reducing the sum to determine the first birth card, and then further reducing it to find the second birth card, with examples.

How to Calculate Your Tarot BirthChart ✨

#tarotreadersoflemon8 #tarotforbeginners #tarot #birthchart #birthchartreading @ Portland 👍

18 likes

#ANewBirthCertificate

0 likes

Your Birth Date determines your dessert! 🧁 (Pt 2)

Find the other months on my part 1 post #desserts #cakeideas #birthday #Lemon8 #fyp

51 likes

The image displays the title "If Birth Dates Were Warnings:" in bold black text on a light gray, textured background. Lemon8 branding and usernames are visible at the bottom.

This image describes personality traits for those born on the 1st, 10th, 19th, or 28th, highlighting their independence, drive, hidden fear of weakness, and need for unwavering support. Lemon8 branding is at the bottom.

This image describes personality traits for those born on the 2nd, 11th, 20th, or 29th, emphasizing their deep emotional capacity, tendency to absorb others' feelings, hidden self-blame, and need for reciprocal care. Lemon8 branding is at the bottom.

What your birth date means! (not original)

#trend #meaningful #birthmonth #philosophy

9 likes

Your prom dress is based off your birth date!

Part 2 is out now!! #dress #Lemon8 #lemon8beauty #birthday #promdress

324 likes

Updating your Birth Certificate in 2025 🏳️‍⚧️

#FTM #transgender #ftmtransgender #birthcertificate #namechange

9 likes

A box filled with various colorful macarons, including black, brown, pink, blue, green, and white, with a text overlay stating "your dessert is based off your birth date."

A close-up of freshly baked chocolate brownies, cut into squares and resting on parchment paper, with the word "JULY" overlaid.

Two baking pans filled with warm, glazed cinnamon rolls, topped with white icing, with the word "AUGUST" overlaid.

Your birth date determines your dessert! 🍪

Stay tuned for more!! #Lemon8Diary #dessert #birthday #snacks #Lemon8

188 likes

A vibrant image featuring bookshelves filled with books, string lights, and vinyl records on the wall. Overlayed text reads 'BOOKS I think you should read BASED ON YOUR BIRTH MONTH' with blue heart accents.

A hand holds the book 'JUST FOR THE SUMMER' by Abby Jimenez, featuring a couple on a beach. The image is labeled 'JUNE' with keywords: meet cute (online), golden retriever MMC, and found family, set against a backdrop of bookshelves.

A hand holds 'THE DO-OVER' by Lynn Painter, depicting cartoon cars and people. The image is labeled 'MAY' with keywords: Valentine's day, over & over, softie FMC, and rom com vibes, placed on a plaid blanket.

Your Birth Month > Your Book (PT. 2)

PURELY BASED ON VIBES >>>>>What book did you get?! ☀️ JUST FOR THE SUMMER: Ultimate summer read with complex characters and a DEEL plot. Funny, emotional, and all around a great story. Online meet cute turns into the FMC travel nurse taking a job in the town where the MMC is.

145 likes

Ever Wonder How To Calculate Cuts?

🛑 before you buy supplies for your next project and Steal My Cutting Process Have you ever wondered how to calculate a project? Well I am definitely not a math girly so if I can do it you can too! 👩🏽‍🎨First use painters’ tape to create a visual representation of how the build will fit in the

67 likes

When I first got pregnant I had absolutely no idea what to expect. I felt super overwhelmed with all the information there was to learn. I made this birth plan to help me during that time. However, I’ve modified it to help you guys out! I know how stressful and overwhelming everything can be. Every

97 likes

A cosmic image with stars, nebulae, and planets, featuring text that asks, "Did You Know ChatGPT Can Read Your Birth Chart?" and instructs to "Swipe for the prompt." A white butterfly silhouette is also visible.

ChatGPT Can Read Your Birth Chart? ✨

Most people don’t realize that ChatGPT can analyze your astrological birth chart just like a professional astrologer! Just provide your birth date, time, and location, and it can reveal: ♈ Your Sun, Moon, and Rising Signs – The “Big Three” that shape your core personality, emotions, and first im

542 likes

A colorful Pythagorean numerology chart titled 'The Meanings in your Name, Birth Date & Important Life Possibilities,' showing letters mapped to numbers 1-9. It details how to calculate 'The Four Life Vibrations of Our True Self' (Soul, Personality, Destiny, Life Lesson) from names and birth dates, with examples, and also includes calculations for Daily Vibration and Address Numbers.

Numerology isn’t about predicting the future — it’s about understanding patterns. Your name, your birthdate, and even repeating numbers point to strengths, challenges, and lessons that tend to show up again and again until they’re integrated. Once you start healing, you notice these patterns ev

239 likes

A woman with a headscarf is drawing a birth chart on a wooden table, surrounded by lit candles, crystals, and astrology books. The image features the text overlay "HOW TO DO YOUR BIRTH CHART MANUALLY" and a Lemon8 watermark.

How to do your birth chart manually

HOW TO DO YOUR BIRTH CHART MANUALLY (Old School, Wise Woman Style) If you really wanna learn your birth chart by hand, it’s like learning to read the sky literally. It ain’t just numbers and planets, it’s a map of you. Here’s how to get into it: What You’ll Need to Start: 1. Your Exact Bi

144 likes

SQL calculate first day of month (part 2)

how to calculate the first day of the month in SQL #dataanalyst #analyst #dataanalytics

0 likes

A woman sits on a sofa with green pillows, holding white roses. Overlaid text provides a motivational quote for January: "You've carried more than you admit... let your growth be the loudest thing about you."

A woman sits on a kitchen counter with a laptop. Overlaid text provides a motivational quote for February: "Your ideas aren't too big... Keep building, your time is catching up to your vision."

Day 11✨📝Diary for your birth month quote P.1

Why birth month quotes should be motivational 💪🏼 Personalized connection: A quote tailored to your birth month can feel like a personal message from the universe, offering a unique sense of connection and validation. Source of inspiration: They serve as a source of inspiration and guidance, es

7 likes

TTC: Calculate your ovulation day🥰

Calculate your ovulation day can help you catch the fertility window and raise the possibility to get pregnancy. Generally speaking, using OPK (ovulation predictor kit) is a common way to track your cycle. #ttc #ovulation #pregnancy #mommed #tips

9 likes

Calculate Your Down Payment On A 🚗

@Welcome Baddies Calculating your down payment for a car using a specific percentage of the total vehicle cost allows for a structured approach to budgeting and affords the benefit of securing more favorable financing terms, potentially resulting in lower monthly payments and reduced interest

425 likes

MY UNFILTERED BIRTH STORY: as a 1st time premiemom

PART 2: MY UNFILTERED BIRTH STORY 🤰🏼 The big moment of my 2nd pregnancy & the complete opposite of my 1st pregnancy! With @princessa.azabae I had to be induced to evict her from my uterus LOL. With this one, she wanted to come out over a month early from her estimated due date 😂 I L

91 likes

How To Calculate Your Risk For Insulin Resistance

How To Calculate Your Risk For Insulin Resistance From Your Yearly Lab work. Go to www.fgsprotocol.com to get the two natural products- FGS Protocol directly through the manufacturer. It’s a protocol that fixes insulin resistance and lowers the sticky fat, triglycerides! #type2diabetes

18 likes

The Pattern Audit: What Your Date Reveals

You were never “too sensitive” or “too stubborn.” Society labels these as personality quirks; at The Desk, we identify them as predictable operational blueprints. Here is the diagnostic breakdown of your default system: • The Sovereign (1, 7, 13, 19, 25, 31): Built for control. You build empi

2 likes

Your Birthday Reveals Your Soul’s Tarot Blueprint

When I first studied tarot, I had no idea what birth card was. Upon reading it in my books, this is what I gathered from it. A birth card in tarot is like your personal energetic blueprint, it’s calculated from your date of birth and reflects your core life themes, strengths, and lessons. Think

39 likes

How to Calculate Square Root in Excel

In this video, I will be explaining how to Estimate Square Root in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

0 likes

How to Calculate Values in Excel

How to Calculate Values in Excel #excel #exceltips #exceltipsandtricks #exceltricks #exceltutorial

0 likes

The image is a title slide for "PHASE 1: NUMEROLOGY" from @THE.DIVINE.ACADEMY, titled "How to Calculate Your Soul Urge & Expression Numbers." It states both numbers come from your full birth name, with a "SWIPE" prompt.

This slide, titled "Step 1: Write Your Full Birth Name," instructs to use the name on your birth certificate, giving "Jane Marie Doe" as an example. It explains numerology assigns numbers to each letter.

The image displays a "Letter to Number Chart" for numerology, showing which letters correspond to numbers 1 through 9. It notes this chart is used for both Soul Urge and Expression numbers.

How to Calculate Your Soul Urge & Expression #'s

Your Life Path isn’t the whole chart. Your Soul Urge reveals what truly fulfills you internally, while your Expression number shows the talents and abilities you bring into the world. Understanding all three gives you a much clearer picture of your energetic blueprint. #Numerology #SoulUrge

25 likes

My First Birth Story

#mybirthstory #lemon8challenge it all began at about 3am I’m 18 yrs old and I just woke up in a sopping puddle. Exactly 1 month before my due date. I’m scrambling to the bathroom to sit on the toilet and blowing up my aunt trying to get information about what’s happening. Thankfully she made me

477 likes

A circular due date calculator is overlaid on a field of green plants with yellow flowers. Text asks, "How to calculate your own due date & why it's important."

A woman smiles while holding a yellow flower, with greenery in the background. Text states her favorite method for calculating due dates is the Mittendorf-Williams rule.

A park scene with large trees and green grass under a cloudy sky. Text suggests finding a due date calculator on the Mama Natural website.

Calculating your DUE DATE!

When calculating your own due date in pregnancy, the Mittendorf-Williams Rule uses 16 different factors—maternal age, pre-pregnancy weight, race, college education, alcohol and coffee use, hypertension, and other medical conditions—that provide a more accurate way of dating pregnancy and identifyin

15 likes

A calculator screen displaying the question: 'How to calculate how many hours a day to watch a show to finish it.'

A calculator screen showing the instruction: 'First count the number of episodes you need to finish.' with the number '44' displayed.

A calculator screen showing the instruction: 'Multiply it by the time it takes to watch each episode' with the calculation '44x0.42' and result '18.48'.

how to calculate how many hours a day to watch a s

3 likes

Bible date with Hubs. Day 5

How to apply this to our lives 💕

45 likes

Calculate Your Debt-To-Income Ratio

@Welcome Baddies 1. Calculate Your Monthly Debt Payments - Add up minimum monthly payments for all debts (credit cards, loans, etc.) - Do not include rent/mortgage, utilities, or other non-debt expenses 2. Divide by Your Gross Monthly Income - Debt Payments / Gross Income = Debt-to-In

160 likes

A notebook page with handwritten notes explaining cardiac rhythms and ECG interpretation, featuring a diagram of an ECG waveform with labeled P wave, QRS complex, and T wave, along with intervals. The title asks, "Do you know how to calculate an ECG yet?"

A clear diagram illustrating a single ECG waveform, precisely labeling the P wave, PR segment, QRS complex (R, Q, S), ST segment, T wave, PR interval, and QT interval.

A detailed ECG grid showing a waveform with P, Q, R, S, T, U waves, and measurements for time (0.04 sec, 0.2 sec, 1 sec) and voltage (1 mV), indicating paper speed of 25 mm/sec.

Do you know how to calculate an ECG yet? 🫀

If you’re starting out with ECGs, it can be tricky, but once you understand the basics, it gets a lot easier! What is an ECG? An Electrocardiogram (ECG) measures the electrical activity of your heart. It’s key for detecting heart problems, and to read it, you need to understand the different part

50 likes

What does your birth date say about you? 👀

Most people don’t realize this— Your birth date isn’t random. It forms a pattern. And that pattern affects: how you think how you react how you show up in relationships and why certain things keep repeating in your life If you’re curious— Comment your birth date (MM/DD/YYYY) ↓ I

16 likes

SQL calculate first day of the month

data analyst calculate first day of the month in SQL #dataanalytics #analyst #dataanalyst

5 likes

Attraction on your by birth date

1 like

A woman in a white blazer sits at a desk, reviewing documents and an open book. Overlay text reads "APPS THAT WILL CALCULATE YOUR Taxes," serving as the title card.

A laptop with a rose gold keyboard and a smartphone are visible inside a car. Overlay text lists popular tax preparation software options.

Books and a water bottle rest on a car seat. Overlay text lists mobile tax application options, including an official government app.

Apps That Will Calculate Your Taxes

@Welcome Baddies Tax calculation apps range from comprehensive software like TurboTax to mobile apps like IRS2Go. These tools help users input their financial information, apply relevant deductions and credits, and calculate tax liability or refunds. While convenient, it's important to ch

70 likes

How to find Hekate in your birthchart

Where is Hekate in your chart? How to find Hekate placement in your birthchart. #Hekate #hecate #asteroid100 #hekateplacement #astrology

6 likes

Quit Changing the One You Date

#relationshipadvice #datingadvice #growthmindset #modernrelationships #marriagetalk #relationshiptruth #selfgrowth #toxicpatterns #highvaluemindset #relationshipcoach #compatibility #lifepath #alignedlove #relationshipalignment #SYRASAGE

0 likes

My positive birth story as a first time mom

I wanted to pop in and share a positive birth story, because I feel like there are so many posts and stories that focus on what went wrong. As a first time mom who has been manifesting a perfect home birth since I was in high school, all I wanted to read were positive stories of quick, vaginal, unm

125 likes

#gettoknowme This is how long I have been in this flash bag. ⭐️Overall rating: /10:

0 likes

My Birth Plan vs. What Actually Happened

On a positive note 📝, What WAS on my birth plan that actually happened: •they did allow me to try to naturally labor without pain medication for as long as my body could handle •they gave me time to process decisions with my support team •breastfeeding only and to bring colostrum collected

365 likes

due date vs birth date🗓️

Some babies are early, some are late… ours? Perfectly on time ⏰💖 #rayannafaye #duedatevsbirthdate #baby #mom

117 likes

See more