In this Excel tutorial, you will learn how to convert Hijri to Gregorian dates in Excel with a simple method.
#exceltips #exceltricks #exceltutorial #excel #excelinhindi
Function ConvertDate(ByRef StringIn As String) As String
Dim SavedCal As Integer
Dim d As Date
Dim s As String
SavedCal = Calendar
Calendar = 1
d = CDate(StringIn)
Calendar = 0
s = CStr(d)
ConvertDate = Format(s, "dd/mm/yyyy")
Calendar = SavedCal
End Function
Hijri to Gregorian date Formula
=convertdate(H4)
Hijri to Gregorian date Day Formula
=text(B2,"dddd")
We will show you some tips and tricks to simplify your computer's operations. I will try to provide maximum solutions here. I request you watch the entire video and use the pause button to understand every step. I will upload some more basic tutorials in my upcoming videos. If you need help with the related topic, kindly write it in the comment section. My purpose in making this video is to help people who are beginners. I warmly welcome your valuable suggestions.
I am so happy to have you here!
Thanks for coming...
Keep watching and keep learning.
Have a great day.
Disclaimer: This video is only for technical knowledge; always consult an expert for any technical changes to your computer or laptop.
thanks
18 фев 2024