More than 5 years have passed since last update.

生年月日を年齢に変換

GoogleAppsScript

Posted at 2012-04-13

function birth2Age(birth, base) {
  var timezone;
  if (base == null) base = new Date;
  timezone = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();
  birth = Utilities.formatDate(birth, timezone, 'yyyyMMdd');
  return parseInt((Utilities.formatDate(base, timezone, 'yyyyMMdd') - birth) / 10000);
}

birth2Age = (birth, base = new Date) ->
  timezone = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone()
  birth = Utilities.formatDate birth, timezone, 'yyyyMMdd'
  parseInt (Utilities.formatDate(base, timezone, 'yyyyMMdd') - birth) / 10000

スプレッドシートの関数としても使える。

=birth2Age(A3)
=birth2Age(A4, B4)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up