Formulas and Functions
ਇਸ ਕੰਟਰੋਲ ਦੀ ਸੋਧ ਕਰਨ ਨਾਲ ਇਹ ਪੰਨਾ ਆਪਣੇ ਆਪ ਅੱਪਡੇਟ ਹੋ ਜਾਵੇਗਾ

DATE

The DATE function combines separate values for year, month and day, and returns a date/time value. Although dates can usually be entered directly as strings (for example, “31/12/2010”), using the DATE function ensures the date will be interpreted consistently, regardless of the date format specified in your Language & Region settings. All arguments are number values.

DATE(year, month, day)

year: The year to include in the value returned. The value isn’t converted. If you specify 10, the year 10 is used, not the year 1910 or 2010.

month: The month to include in the value returned. month should be in the range 1 to 12.

day: The day to include in the value returned. day should be in the range 1 to the number of days in month.

Notes

  • Language & Region settings are in System Preferences in macOS 12 and earlier, in System Settings in macOS 13 and later, in Settings in iOS and iPadOS, or in your Time Zone & Region settings in iCloud Settings.

Examples

If A1 contains 2014, A2 contains 11 and A3 contains 10:

=DATE(A1,A2,A3) returns 10 Nov 2014, which is displayed according to the cell’s current format.

=DATE(A1,A3,A2) returns 11 Oct 2014.

See alsoDATEVALUETIME
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.