Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas

🤯 Wacky fact of the day · Human Body

You blink around 15–20 times a minute.

Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry…

Why? How? →Source ↗

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Skip to content
  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact

Atul Vij

DATEDIF Function in Excel: Age and Tenure in Years, Months, Days

DATEDIF Function in Excel: Age and Tenure in Years, Months, Days featured illustration

16 May 2019 · Date & Time · 1 min read

DATEDIF Function in Excel: Age and Tenure in Years, Months, Days

DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.

Read article →
16 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

JSON Explained Simply (for Excel People)

JSON Explained Simply (for Excel People) featured illustration

14 May 2019 · Dev Tools · 1 min read

JSON Explained Simply (for Excel People)

What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query…

Read article →
14 May 2019 by Atul Vij Dev Tools

PERMUT Function in Excel: Arrangements Where Order Matters

PERMUT Function in Excel: Arrangements Where Order Matters featured illustration

7 May 2019 · Excel Functions A–Z · 1 min read

PERMUT Function in Excel: Arrangements Where Order Matters

PERMUT counts ordered arrangements — podium positions, codes without repeated digits.

Read article →
7 May 2019 by Atul Vij Excel Functions A–Z, Statistical

EDATE Function in Excel: Add or Subtract Months From a Date

EDATE Function in Excel: Add or Subtract Months From a Date featured illustration

5 May 2019 · Date & Time · 1 min read

EDATE Function in Excel: Add or Subtract Months From a Date

EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.

Read article →
5 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

EOMONTH Function in Excel: Last Day of a Month

EOMONTH Function in Excel: Last Day of a Month featured illustration

5 May 2019 · Date & Time · 1 min read

EOMONTH Function in Excel: Last Day of a Month

Date & TimeLevel: IntermediateAvailable in: Excel 2007+EOMONTH returns the last day of the month, a number of months away from a.

Read article →
5 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

YEAR Function in Excel: Year From a Date

YEAR Function in Excel: Year From a Date featured illustration

3 May 2019 · Date & Time · 1 min read

YEAR Function in Excel: Year From a Date

YEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month (1–12) and day (1–31).

Read article →
3 May 2019 by Atul Vij Date & Time, Excel Functions A–Z

PowerPoint Slide Master: Fix Every Slide in One Place

PowerPoint Slide Master: Fix Every Slide in One Place

2 May 2019 · PowerPoint · 2 min read

PowerPoint Slide Master: Fix Every Slide in One Place

Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…

Read article →
2 May 2019 by Atul Vij PowerPoint

COMBIN Function in Excel: How Many Groups Are Possible

COMBIN Function in Excel: How Many Groups Are Possible featured illustration

30 Apr 2019 · Excel Functions A–Z · 1 min read

COMBIN Function in Excel: How Many Groups Are Possible

COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.

Read article →
30 April 2019 by Atul Vij Excel Functions A–Z, Math & Trig

MONTH Function in Excel: Month Number From a Date

MONTH Function in Excel: Month Number From a Date featured illustration

29 Apr 2019 · Date & Time · 1 min read

MONTH Function in Excel: Month Number From a Date

MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.

Read article →
29 April 2019 by Atul Vij Date & Time, Excel Functions A–Z

REPT Function in Excel: Repeat Text (In-Cell Bar Charts)

REPT Function in Excel: Repeat Text (In-Cell Bar Charts) featured illustration

26 Apr 2019 · Excel Functions A–Z · 1 min read

REPT Function in Excel: Repeat Text (In-Cell Bar Charts)

REPT repeats text a number of times — best known for quick bar charts inside cells.

Read article →
26 April 2019 by Atul Vij Excel Functions A–Z, Text

WEEKDAY Function in Excel: Day of the Week as a Number

WEEKDAY Function in Excel: Day of the Week as a Number featured illustration

25 Apr 2019 · Date & Time · 1 min read

WEEKDAY Function in Excel: Day of the Week as a Number

WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend…

Read article →
25 April 2019 by Atul Vij Date & Time, Excel Functions A–Z

DATE Function in Excel: Build a Date From Year, Month and Day

DATE Function in Excel: Build a Date From Year, Month and Day featured illustration

22 Apr 2019 · Date & Time · 1 min read

DATE Function in Excel: Build a Date From Year, Month and Day

DATE creates a real date from separate year, month and day numbers — the reliable way to put dates in formulas.

Read article →
22 April 2019 by Atul Vij Date & Time, Excel Functions A–Z

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →