comparing lunar (Hijri) day with a number
 

Im trying to compare a date off the Islamic calendar to see if that day its
greater then 15.
the cells in column "A" are the Julian/Gregorian date;
in "B" are the dates whit the format "[$-1060000]B2d;@" , to return only
the day,
and in C the expected result ; so I have:

A B C
2006/09/08 15 FALSE
2006/09/01 8 TRUE

Q : WHAT IS THE FORMULA IN « C » ?

Thank's for the help.

comparing lunar (Hijri) day with a number
 

Hi Mossi,

For a date in A1,
=VALUE(TEXT(A1,"[$-1060000]B2d;@"))<15

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Mossi" wrote in message ...
Im trying to compare a date off the Islamic calendar to see if that day its
greater then 15.
the cells in column "A" are the Julian/Gregorian date;
in "B" are the dates whit the format "[$-1060000]B2d;@" , to return only
the day,
and in C the expected result ; so I have:

A B C
2006/09/08 15 FALSE
2006/09/01 8 TRUE

Q : WHAT IS THE FORMULA IN « C » ?

Thank's for the help.

comparing lunar (Hijri) day with a number
 

Always learnig...
Tanks