ExcelExciting

/*
--------------------- CENTER OF GRAVITY ---------------------
*/
CENTEROFGRAVITY = LAMBDA(xLongitudes, yLatitudes, Volume,
    
/* The Center of Gravity method helps you find a central point that minimizes the transportation distance to all your destinations. 
Think of it as finding the balance point on a seesaw, where all weights (shipments) are balanced.

blog_web_link: https://excelexciting.com/how-to-calculate-center-of-gravity-to-find-a-distribution-center-using-microsoft-excel/

ExcelExciting

/*
--------------------- MATHS TABLES ---------------------
*/
TABLES=
LAMBDA(Table_Of,[Until],
/* Mathematics Tables, It is fun to have our tables in excel. 
I saw many teachers are struggling to make table in word or in excel. 
So here is the simple Excel Function that can return to us the table. 
By defaults take only 12 times [Until] and you are flexible to change it as per your need.

ExcelExciting

/*
--------------------- CONVERT DATE TO WORD ---------------------
*/
DATETOWORD=LAMBDA(ExcelDate,
/*Convert Date to word
We offent time need to convert a date to text form or in word from. 
With this lambda function you can easily convert a date to word form.

IMPORTANT : Entering date will be depending on your systme local settings.

ExcelExciting

/*
--------------------- CBM CONVERTER ---------------------
*/
CBMCONVERTER = 
/*Calculate Cubic Meters (CBM)
Calculate Cubic Meters (CBM). CBM Converter allow you to measure your cargo volume in CBM (m³). 
CBM calcuation is widely use in shipping/logistics industry to calculate a cargo volume.

author,"Faraz Shaikh, Microsoft® MVP",
wesite,"www.ExcelExciting.com",

ExcelExciting

STACKDATA =
/*Stacking you data one upon another selected range.
YouTube Link: https://youtu.be/LyAY7WNpIKQ
SYNTAX:
=STACKDATA(DataRange,[Data_Orientation],[Transpose_Data])
+Name+Company+
+Faraz+Microsoft+
+Nisha+Apple+
 
RESULT01>> =STACKDATA(DataRange,0)

ExcelExciting

=TEXT(INT(DATEDIF([DOB],TODAY(),"D")/(12*29.530575)),"00")&" years "&
TEXT(INT(((DATEDIF([DOB],TODAY(),"D")/(12*29.530575)-INT(DATEDIF([DOB],TODAY(),"D")/(12*29.530575)))*12)),"00")&" months "&
TEXT(INT((((DATEDIF([DOB],TODAY(),"D")/(12*29.530575)-INT(DATEDIF([DOB],TODAY(),"D")/(12*29.530575)))*12)-INT(((DATEDIF([DOB],TODAY(),"D")/(12*29.530575)-INT(DATEDIF([DOB],TODAY(),"D")/(12*29.530575)))*12)))*29.530575),"00")&" days"

ExcelExciting

HIJRIAGE =
/*Hijri Age Calculator allows you to calculate the age of person as per arabic calander.
https://excelexciting.com/how-to-calculate-hijri-age-in-excel/
EXAMPLE:
=HIJRIAGE("3/3/1991") 
RESULT>> 31 years 10 months 25 days 
If you like to cacluate the Gregorian Age then you need enter next argument as "g"
EXAMPLE:
=HIJRIAGE("3/3/1991","g") 
RESULT>> 30 years 11 months 11 days

ExcelExciting

/*
TIRED OF WRITING EXCEL FORMULA AGAIN AND AGAIN, WELL EXPORT THIS LAMBDA LINK INTO YOU EXCEL WORKBOOK AND ENJOY THE USING THE CODE. DON'T FORGET THE SHARE AND LIKE.
EACH LAMBDA IS CREATED BY DIFFERENT AUTHOR, PLEASE REFER TO DETAILS WITHIN EACH FORMULA
*/

/*
--------------------- HIJRI AGE CALCULATOR ---------------------
*/
HIJRIAGE =
/*Hijri Age Calculator allows you to calculate the age of person as per arabic calander.