[Excel] boss solid praise ♡ closing date automatic input

@ ruri.excel 2019 Wormama's post is here 🎀

Comment 🎀 if 🥹 want to try it 🤍

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

🦢🫧 How to Autofill Invoice Deadline

Commentary

🎀 TODAY function

"Auto-enter today's date"

= TODAY ()

You don't have to put anything in ()!

🎀 EOMONTH function

Automatically enter the end of the month for the specified date

= EOMONTH (enter date directly or date cell, 1)

"1" means "one month later 💡

Example) Billing date is "2025/8/21"

If the cell on the billing date is A1

= EOMONTH (A1,1) for "2025/9/30" ✨

If you want to be at the end of the month, enter "0."

= EOMONTH (2025/8/31) 😌

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Thank you for your likes and comments 🤍

It has become my driving force and encouragement 😌

It is convenient to save and look back from "• • •" at the bottom right 🌸

On this account.

I don't have time to study for skill improvement with overtime every day

i don't have the money or time, so i just let my kids be patient.

In this life, balancing work and childcare is absolutely impossible...

▸ ▸ Ruri who has overcome

🩰 I want to learn Excel in a gap time and improve my skills

🍒 I want to increase time with irreplaceable children by leaving work on time

🎀 want to enjoy the office life in the work technique

Someone who had the same problems as me in the past.

I will send out to save 🐈‍⬛🌙

Please see other posts from @ ruri.excel if you like 🌷

# excel # excel # excel _ beginner # work efficiency # wahmama