Hi Sumesh
Please see the attached file. It has both conversions.
On Tue, Apr 28, 2015 at 11:14 AM, Sumesh Nair wrote:
> Hi Excel Beginner,
>
> I want your help in converting the date in two columns in Excel.
>
> If in one column(A1) I will enter Hijri Date the next column(B1) should be
> change
Hi Excel Beginner,
I want your help in converting the date in two columns in Excel.
If in one column(A1) I will enter Hijri Date the next column(B1) should be
changed to English date.
Please help me to solve this problem
Thanks & Regards,
Sumesh Nair
On Tuesday, September 25, 2012 at 8:15:
Hi Excel Beginner,
Thank you for posting the conversion file from Gregorian into Hijri.
Do you mind sharing the formula to make it the other way, i.e. from Hijri
into Gregorian please?!
Many thanks!
Ziad
On Tuesday, September 25, 2012 1:15:05 PM UTC-4, Excel Beginner wrote:
>
> Hi Ahmed,
>
Hi :Mr. Excel Beginner,
Bravo and a Bravo again, Hats off for your DAMN simple solution, really
appreciate that.
If you don't mind can you explain me what does this mean in the formulae *
[$-117]B2dd-mm-;@*
specially that *$* sign, *117*, *;* and *@*
Thanks once again you made my da
Hi Ahmed,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Sep 25, 2012 at 3:27 PM, Ahmed Honest wrote:
> Dear All,
>
> Please find attach the Raw Data sheet from which I need to convert a
> Gregorian Date to a Hijri Date and pull out the Day, Month, Year from t
Hi,
Use Shortcut key: - Ctrl + Shift + # (Hijri Date Column).
and use Day, Month, Year formula Hijri date column.
Regards,
Kuldeep Singh
On Tue, Sep 25, 2012 at 3:27 PM, Ahmed Honest wrote:
> Dear All,
>
> Please find attach the Raw Data sheet from which I need to convert a
> Gregorian Date t
Dear All,
Please find attach the Raw Data sheet from which I need to convert a
Gregorian Date to a Hijri Date and pull out the Day, Month, Year from the
Hijri Date.
Any help on this will be appreciated.
Thanks,
--
Ahmed Bawazir
*احمد باوزير*
--
Join official facebook page of this forum @
ht