comparing lunar (Hijri) day with a number

M

Mossi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top