# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/DateTimeExcel/DateParts.php

TablePress – Tables in WordPress made easy, version 3.4. 155 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/DateTimeExcel/DateParts.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/DateTimeExcel/DateParts.php
- Modified: 2025-08-26T04:06:14+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/DateTimeExcel/DateParts.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\DateTimeExcel;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\ArrayEnabled;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Shared\Date as SharedDateHelper;

class DateParts
{
	use ArrayEnabled;

	/**
	 * DAYOFMONTH.
	 *
	 * Returns the day of the month, for a specified date. The day is given as an integer
	 * ranging from 1 to 31.
	 *
	 * Excel Function:
	 *        DAY(dateValue)
	 *
	 * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer),
	 *                                    PHP DateTime object, or a standard date string
	 *                         Or can be an array of date values
	 *
	 * @return array<mixed>|int|string Day of the month
	 *         If an array of numbers is passed as the argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function day($dateValue)
	{
		if (is_array($dateValue)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $dateValue);
		}

		$weirdResult = self::weirdCondition($dateValue);
		if ($weirdResult >= 0) {
			return $weirdResult;
		}

		try {
			$dateValue = Helpers::getDateValue($dateValue);
		} catch (Exception $e) {
			return $e->getMessage();
		}

		// Execute function
		$PHPDateObject = SharedDateHelper::excelToDateTimeObject($dateValue);
		SharedDateHelper::roundMicroseconds($PHPDateObject);

		return (int) $PHPDateObject->format('j');
	}

	/**
	 * MONTHOFYEAR.
	 *
	 * Returns the month of a date represented by a serial number.
	 * The month is given as an integer, ranging from 1 (January) to 12 (December).
	 *
	 * Excel Function:
	 *        MONTH(dateValue)
	 *
	 * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer),
	 *                                    PHP DateTime object, or a standard date string
	 *                         Or can be an array of date values
	 *
	 * @return array<mixed>|int|string Month of the year
	 *         If an array of numbers is passed as the argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function month($dateValue)
	{
		if (is_array($dateValue)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $dateValue);
		}

		try {
			$dateValue = Helpers::getDateValue($dateValue);
		} catch (Exception $e) {
			return $e->getMessage();
		}
		if ($dateValue < 1 && SharedDateHelper::getExcelCalendar() === SharedDateHelper::CALENDAR_WINDOWS_1900) {
			return 1;
		}

		// Execute function
		$PHPDateObject = SharedDateHelper::excelToDateTimeObject($dateValue);
		SharedDateHelper::roundMicroseconds($PHPDateObject);

		return (int) $PHPDateObject->format('n');
	}

	/**
	 * YEAR.
	 *
	 * Returns the year corresponding to a date.
	 * The year is returned as an integer in the range 1900-9999.
	 *
	 * Excel Function:
	 *        YEAR(dateValue)
	 *
	 * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer),
	 *                                    PHP DateTime object, or a standard date string
	 *                         Or can be an array of date values
	 *
	 * @return array<mixed>|int|string Year
	 *         If an array of numbers is passed as the argument, then the returned result will also be an array
	 *            with the same dimensions
	 */
	public static function year($dateValue)
	{
		if (is_array($dateValue)) {
			return self::evaluateSingleArgumentArray([self::class, __FUNCTION__], $dateValue);
		}

		try {
			$dateValue = Helpers::getDateValue($dateValue);
		} catch (Exception $e) {
			return $e->getMessage();
		}

		if ($dateValue < 1 && SharedDateHelper::getExcelCalendar() === SharedDateHelper::CALENDAR_WINDOWS_1900) {
			return 1900;
		}
		// Execute function
		$PHPDateObject = SharedDateHelper::excelToDateTimeObject($dateValue);
		SharedDateHelper::roundMicroseconds($PHPDateObject);

		return (int) $PHPDateObject->format('Y');
	}

	/**
	 * @param mixed $dateValue Excel date serial value (float), PHP date timestamp (integer),
	 *                                    PHP DateTime object, or a standard date string
	 */
	private static function weirdCondition($dateValue): int
	{
		// Excel does not treat 0 consistently for DAY vs. (MONTH or YEAR)
		if (SharedDateHelper::getExcelCalendar() === SharedDateHelper::CALENDAR_WINDOWS_1900 && Functions::getCompatibilityMode() == Functions::COMPATIBILITY_EXCEL) {
			if (is_bool($dateValue)) {
				return (int) $dateValue;
			}
			if ($dateValue === null) {
				return 0;
			}
			if (is_numeric($dateValue) && $dateValue < 1 && $dateValue >= 0) {
				return 0;
			}
		}

		return -1;
	}
}

```