Posted to microsoft.public.excel.worksheet.functions

Mossi

external usenet poster

Posts: 4

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing Data	Speedy Brewskie	Charts and Charting in Excel	7	February 9th 07 02:41 PM
Comparing data	Abas Ibrahimov	Excel Worksheet Functions	2	September 28th 06 07:04 AM
comparing a value in a cell to see if it is higher than a number	PK	Excel Worksheet Functions	9	June 2nd 05 03:35 PM
Comparing incomparable	Bas Avel	Charts and Charting in Excel	2	March 4th 05 06:18 AM

All times are GMT +1. The time now is 01:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us