Dear Ahmed,
We have to get to this solution Step by Step:
1) Convert Windows and Excel to recognize Hijri Date.
2) Resolve your query on the expiry date.
1) To use the Hijri date format in Windows and subsequently in Excel, you
need to follow the following steps:
The following steps show how we can custom the date in the cells, to be
entered as Gregorian format and interpreted in Hijri format, also we will
describe how we can enter a date in Hijri format in a cell.
*Type a date in Gregorian format and have Excel interpret it as Hijri date*:
1. On the Format menu, click Cells, and then click the Number tab.
2. From the Type list select the Hijri format that you want to use and
press OK, or continue to proceed in the next steps (Step 3)
3. Select Custom from the list of categories.
4. In the Type box, do one of the following:
1. B1dd/mm/yy - To display dates using the Gregorian calendar,
regardless of the Regional Options or Regional Settings of the Microsoft
Windows Control Panel setting, type B1 before the date format.
2. B2dd/mm/yy – to type the date in Gregorian format but it will be
interpreted and displayed as Hijri date.
This means that Arabic editing is enabled, to display dates using the Hijri
calendar and regardless of the Regional Options or Regional Settings
setting, type B2 before the date format code. Note It is also possible to
format the date by changing the locale selected in the Locale (location) box
for the Date category on the Number tab and then selecting a date format in
the Type box.
*Type a date in a cell in Hijri format.*
The following method will work only on Arabic Office SKU.
To enable this method for non Arabic SKU’s; you will need to add the
following registry key: HKCU\Software\Microsoft\Office\11.0\Excel\Options\
Value = xl9_hijri
Value Type = DWORD
Value Data = 0
To enter Hijri date, type A or a in front of the date entry
For example, you can enter the short date 'a9/25/20', which will be
interpreted as Hijri date 9/25/1420 (this is Gregorian date 1/1/2000). If
the cell is unformatted, it will be assigned the number format 'B2m/d/yyyy'
and the value will be displayed as '9/25/1420' Note Your regional settings
affect how Excel recognizes the day, month and year parts of the value
entered. For example, when using English (United States) regional settings,
you should enter the Hijri value as 'a9/25/20'. When using Arabic (Egypt)
regional settings, you should enter the Hijri value as 'a25/9/20' Additional
keywords
For more details you can visit the following link:
http://support.microsoft.com/kb/871138
Once the above is achieved, your query can be easily resolved.
But first, lets complete the first thing before you move to the resolution
number 2.
Regards,
Andy
On Thu, Nov 26, 2009 at 3:25 PM, Ahmed Emam <aaa222e...@gmail.com> wrote:
> Hi Gurus ,
>
> I need a conditional formatting for this excel sheet which is supposed to
> give me warning for expiry
> date of residential permit , but my problem is my windows date & time is
> Gregorian & this dates are
> in Hijri format.
> I need it to warn me a month before expiry date .
> Can anyone help me here ?
>
> Thanks & Best Regards
> --
> A.A.A.
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
