Posted to microsoft.public.excel.misc

Gary''s Student

Posts: n/a

Sort by Hebrew Date

Excel can handle the year, but the months and days do not map directly. If
you format the dates as integers in the form yyyymmdd, always using 2 digits
for the month and day, the standard numerical sort might work.
--
Gary's Student

"Desperate Dan" wrote:

Does anyone know if (and how) Excel's sort by date function can be used to
sort by Hebrew date rather than English Date?

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
Another Date issue.	TimM	Excel Worksheet Functions	1	November 17th 05 01:58 AM
How do you sort a date range by month?	Brewisc13	Excel Discussion (Misc queries)	13	July 7th 05 06:45 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Excel 2003 "File Open": how keep folders at top with sort by Date.	Aging Analyst	Excel Discussion (Misc queries)	1	December 3rd 04 03:26 AM

All times are GMT +1. The time now is 11:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us