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
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










