Formulas and Functions
ଏହି କଣ୍ଟ‍୍ରୋଲ୍‌କୁ ପରିବର୍ତ୍ତନ କରିବା ଫଳରେ ଏହି ପୃଷ୍ଠା ସ୍ବୟଂଚାଳିତ ଭାବରେ ଅପ୍‌ଡେଟ୍ ହୋଇଯିବ

DATEVALUE

The DATEVALUE function returns a date/time value for a given date string. This function is provided for compatibility with other spreadsheet apps.

DATEVALUE(date-text)

date-text: The date string to be converted or a date/time value. If date-text is not a valid date, an error is returned.

Examples

If cell B1 contains the date/time value 2 Aug 1979 06:30 am and cell C1 contains 16/10/2008 formatted as text:

=DATEVALUE(B1) returns 2 Aug 1979, and is treated as a date value if referenced in other formulas. The value returned is formatted according to the current cell format. A cell formatted as Automatic uses the date format specified in your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS).

=DATEVALUE(C1) returns 16 Oct 2008.

=DATEVALUE("12/29/1979") returns 29 Dec 1979.

See alsoDATETIME
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.