| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
comparing lunar (Hijri) day with a number
Always learnig...
Tanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Data | Charts and Charting in Excel | |||
| Comparing data | Excel Worksheet Functions | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| Comparing incomparable | Charts and Charting in Excel | |||
Hybrid Mode
