comparing lunar (Hijri) day with a number

[Guest]

I’m trying to compare a date off the Islamic calendar to see if that day it’s
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.

 

[macropod]

Hi Mossi,

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

Cheers

 

[Guest]

Always learnig...
Tanks