

January 24, 2023

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

VIP

Trusted Members

December 7, 2016



Trusted Members

October 17, 2018

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
1 Guest(s)
