calendar

[OBN]

I am working in KSA, they use the Islamic calendar. every time try to get and convert the date from Islamic to normal calendar.
I am trying to find a way to combine 2 to 3 cells in one cell
example

a1=day
b1=month
c1=year
d1 should be = day-month-year

any help in that respect. keeping in mind using Islamic calendar

tks

[gebobs]

I'm not really sure what you are looking for here or what the Islamic calendar is all about, but just to get the conversation started, are you looking for a way to just display the date as such?

If so, the formula for D1 should be: =a1&"-"&b1&"-"&c1

...keeping in mind though that this will only be recognized as text by Excel.

Otherwise, here is an article that explains how to format Islamic calendar dates.