Hi All,
I have copied a simple if formula (it works) but I need to know how, if at all, I can/could change it to English and what the Foreign Language means.
=IF(DaySet=1, IF(WEEKDAY (DATE(Yearset, MONTH (TanggalAwal),1)) = 1, DATE((Yearset, MONTH(TanggalAwal),1),""), IF (WEEKDAY (DATE(Yearset, MONTH(TanggalAwal) ,1)) = 2 ,DATE((Yearset, MONTH(TanggalAwal) ,1) ,"").
Thanks
Hello,
Check in the name manager and you should find the names and their references there. You can rename those, the names will be updated in the formulas as well.
Br,
Anders
I don't think it's the formula the OP is interested in but in what the names it's refering to.
I would suggest, if the user has the file to list all named ranges and the address it refers to.
Excel in any language will not know what the user means with someting like 'TanggalAwal'. Google translate will probably be at loss there too
Hello,
Translations is not really an Excel issue, but anyway. The different translation services on the web says that tanggal awal is start date in the Indonesian language.
Br,
Anders
Like I mentioned, it's probably the name the user gave to either a UDF or a named range.
