Automatically translated.View original post

るん|簡単Excel時短術

1515 followers

Follow

Follow

Follow

83 saved

28

1

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

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

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

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

881 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

10 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

567 likes

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

229 likes

How to Calculate Values in Excel

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

0 likes

How to Calculate Your Tarot BirthChart ✨

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

18 likes

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

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

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

36 likes

Your birth date determines your dessert! 🍪

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

169 likes

What your birth date means! (not original)

#trend #meaningful #birthmonth #philosophy

2 likes

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

541 likes

Unlock the Power of Your Divine Blueprint

Your Birth Date is not random. It is a precise Cosmic Blueprint that dictates your Energy Flow and how you are meant to influence the world around you. Most women spend their lives trying to fit into a mold that wasn't made for them, ignoring their true Archetype. Whether you are a natural L

1 like

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

477 likes

Updating your Birth Certificate in 2025 🏳️‍⚧️

#FTM #transgender #ftmtransgender #birthcertificate #namechange

9 likes

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

372 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

96 likes

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

Your prom dress is based off your birth date!

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

301 likes

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

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

21 likes

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

3 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

23 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

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

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

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

26 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

859 likes

The Truth Behind Your Relationship Energy

Stop wondering why you and your partner clash or why certain connections feel effortless. The Truth is written in your Birth Date. In Digital Psychology, we analyze the Shared Couple Energy - a powerful Vibration created by merging your two individual paths. It is a Cosmic Blueprint of your inte

1 like

The Moon’s Teaching

The Nile Delta- Three Days After First Blood The spiral path had been easy. Too easy, perhaps. Nin-Bar had expected challenge, difficulty, some test that would push her abilities to their limit. Instead, she’d walked the blindfolded path with the same calm precision she brought to everything—

2 likes

Beginners Guide to Removing soy from your diet

Beginner’s Guide to Soy We hope that reading this Beginner’s Guide to Soy will help you better understand Soy Intolerance and Soy Allergy. We are also including many questions and answers that are often asked in our group about Soy and a helpful list that includes sneaky places that you should

0 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

66 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

476 likes

Where is Your Money Hiding?

You might be working hard but standing in the wrong place. In Digital Psychology, your financial success isn't just about effort - it is about Alignment with your unique Vibration. Your Birth Date contains the Secret code to your wealth.To find your money number, use this Self-Discovery calcula

1 like

Bible date with Hubs. Day 5

How to apply this to our lives 💕

44 likes

2 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

How to calculate your life path

yours not in this post? check my account! the rest are there :) #spirituality #lifepathnumber #numerology #astrology #itgiritips

6 likes

Are these true? Write in the comments! Follow for Part Two. Curious what your life path is? Drop your birthdate in the comments, I’ll calculate it for you #fengshui #destiny #astrology #numerology #zodiacsigns

0 likes

Quit Changing the One You Date

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

0 likes

Trying to calculate the ROI in relationships 😵‍💫

Insecurity is afraid of not getting a ROI, while self worth does things by choice and knows when to pull back intuitively. Especially in long term relationship.

0 likes

Want to calculate for you moon & rising .

Time & place born #moonzodiac #risingzodiac #sunzodiac #personal #astrology

3 likes

See more