JIS function. Converts half-width characters to full-width characters.(Microsoft Excel)
Japanese version.
Converts half-width characters to full-width characters.
How it works=JIS(Text)NameOmissio ...ASC function. Converts full-width characters to half-width characters.(Microsoft Excel)
Japanese version.
Converts full-width characters to half-width characters.
How it works=ASC(Text)NameOmissio ...REPLACE function. Replace specified character position & number of characters with specified string.(Microsoft Excel)
Japanese version.
Replace specified character position & number of characters with specified string.
How ...LEFTB, MIDB, and RIGHTB functions. Extracts a portion of a string by specifying the number of bytes.(Microsoft Excel)
Japanese version.
Extracts a portion of a string by specifying the number of bytes.
How it worksLEFTB functi ...DAYS360 function. Calculate the number of days between two dates, using a year as 360 days (12 months x 30 days).(Microsoft Excel)
Japanese version.
Calculate the number of days between two dates, using a year as 360 days (12 months x 30 days ...
NETWORKDAYS and NETWORKDAYS.INTL functions. Retrieve the number of business days for the specified period.(Microsoft Excel)
Japanese version.
Retrieve the number of business days for the specified period.
How it worksNETWORKDAYS: Fi ...DAYS function. Get the number of days between two dates.(Microsoft Excel)
Japanese version.
Get the number of days between two dates.
Although the same result can be obtained by s ...
YEARFRAC function. Get the percentage of the period between the two dates in a year.(Microsoft Excel)
Japanese version.
Get the percentage of the period between the two dates in a year.
How it works=YEARFRAC(St ...WEEKNUM and ISOWEEKNUM functions. Get how many weeks in the year the date is.
Japanese version.
Get how many weeks in the year the date is.
How it worksISOWEEKNUM=ISOWEEKNUM(Date)Argumen ...YEAR,MONTH,DAY,HOUR,MINUTE,SECOND functions. Extract the year, month, date, time, minute, and second.(Microsoft Excel)
Japanese version.
Extract the year, month, date, time, minute, and second.
How it works=YEAR(Serial_number)= ...