How to Calculate Hijri Age In Excel (mac & windows) @ExcelExciting
How to Calculate Hijri Age In Excel (mac & windows)  @ExcelExciting
Uploaded December 2021 | Updated November 2026, 3 days ago
In this video, we will learn a simple way to calculate the Hijri / Arabic age in excel. This is an age calculator as per the Hijri calendar. The calendar is entirely based on the Moon lunation. Hijri calendar started after the migration of the Prophet Mohammed (PBUH ﷺ) from Makkah to Medina. Hijri calendar or Arabic calendar widely used in Islamic countries. It is also known as the Lunar calendar. It contains 12 Islamic months that are depending on the moon’s motion based on the monthly cycles of the Moon’s phases (synodic months or lunations)

⏱ Time Stamp
00:00 Intro
00:24 Basic Understanding Of Hijri Calendar
01:40 Calculate Number of days In Hijri Year
02:14 Calculate Age in the Gregorian / English calendar
02:53 Write Hijri Age Calculator
07:03 Copy Hijri Age Calculator Formula from website
09:10 Copy LAMBDA to calculate Hijri Age
11:04 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
- Buy A Me Coffee - buymeacoffee.com/ExcelExciting

📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨‍👩‍👧‍👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
excelexciting.com/how-to-calculate-hijri-age-in-excel
timeanddate.com/astronomy/moon/lunar-month.html
--------------------------------------------------------------
🌎 ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting

👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well

Extract Number & Text from a Cell in Excel | Solution 01 by Power Query
youtu.be/GHQXgg2PR_k

Excel Tip by the Excel Queen 👸🏻(Faraz & Leila)
youtu.be/6CEYKRIlppE

The easiest way to Unhide All Sheets with one line code [VBA MACRO]
youtu.be/cs8T8gYltvI

Easiest Way to Make Dependent Dropdown List Using XLOOKUP
youtu.be/OYbusivTbN0

***********************************************************
#Excel #FarazShaikh #ExcelExciting #Hijri #ExcelFormulas #Lambda #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
How to Calculate Hijri Age In Excel (mac & windows)Find MAX Value Column & Row Number In Excel Using the New Array Calculation Engine(Example 01)When Time is Tight, Get Your Queries Right with Alejandra Horvath🥇🥈🥉Top N Values | Easy Solution with NEW Dynamic Arrays (macOS & Windows)The Simple Magic of Go To Special with Alison PollecuttHighlight the Highest value row-wise by comparing two columns in Excel📒📚Combine Multiple Excel Worksheets Into One Worksheet | Power QueryUse Excel MAP and LAMBDA Function to Group ValuesExcel Trick# 27 – Extract First Name with Python in Excel #shorts #excel #excelexcitingExcel Trick# 29 – Filter Top 3 Rows Using TAKE & SORT FunctionAI in Power BI with Liji ThomasThe Versatile Lookup Functions with Victor Momoh
Faraz Shaikh |

How to Calculate Hijri Age In Excel (mac & windows)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER