This script will extract the day, the month or the year from a date cell.

 

When I use the script ?

When I have to perform different actions based only on the day, month or year (not the full date)

 

How to create the script ?

Read How to create, edit and select an Office Script in an excel report

 

How to create the button to associate it with the script ?

Read How to create a button and associated it to an Office Script in an excel report

 

How is/are the script(s) ?

Copy the code below and paste it into your script. You will see my comments in green if exist so follow the help to adapt to your need.

function main(workbook: ExcelScript.Workbook) {
  // change sheet1 by yours
  let sheet = workbook.getWorksheet("Sheet1");
  // change A2 by yours where it is the date
  const dnum = sheet.getRange("A2").getValue() as number;
  const dcvt = new Date((dnum - 25569) * 86400000);
  // for day, change getMonth() + 1 by getDate()
  // for year, change getMonth() + 1 by getFullYear()
  let dext = dcvt.getMonth()+1;
  // change B2 by yours where to put the result
  // cell should be formatted as "general"
  sheet.getRange("B2").setValue(`${dext}`)
}