Sort by Hebrew Date

D

Desperate Dan

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

Gary''s Student

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.
 
Top