Gregorian to Hijri date conversion

[adorlytanglao]

I have a column of dates on Column F(Gregorian) and it displays the Hijri dates on Column G. What is did is i formatted the all the cells Column G into

Home -> Number -> DropDown More Number Formats -> Number -> Category -> Date -> Locale(Location) -> Arabic (Saudi Arabia)

Then i just entered on cell G3

=F3

and dragged it down.

My issue is i have some empty cells and its returning a non-empty value specifically "29-08-1317" which is equivalent to January 1, 1900.

How can i make the cells on column G empty if the correspondent cells on F is also empty.

 

[azumi]

=if(f3="","",f3)

 

[adorlytanglao]

That was great, i didnt expect its that simple. Thank a lot. Can you tell me also how to make a thread solved, for example this one. And most importantly, how to give points/upvote to people.

 

[azumi]

No there is not a way to mark the thread as solved.

Your replying with a thanks and an acknowledgement to whether or not you received your answer is the way to go

Thanks for your feedback

 

[adorlytanglao]

Well, in that case, thanks for your help.