DATEVALUE waa shaqo Tariikh^(Date) iyo Waqti^(Time) , ujeeddadeeduna waa in taariikhda qaab qoraal ah loo beddelo lambar taxane ah. Maqaalkan, waxaan ku tusi doonaa sida loo isticmaalo shaqada DATEVALUE ee Microsoft Excel .

Waa maxay habka iyo qaacidada loogu talagalay shaqada DATEVALUE ee Excel^{(Excel DATEVALUE)} ?

Qaabka shaqada DATEVALUE waa DATEVALUE(date_text).

Erayga shaqada DATEVALUE waa:

Date_text : Qoraal ka tarjumaya taariikhda qaab taariikheed. Waa loo baahan yahay.

Sideen ugu isticmaalaa DATEVALUE gudaha Excel?

Shaqada DATEVALUE way fududahay in la sameeyo; waa in aad taqaannaa qaacidada. Tababarkan ayaa ka hadli doona tillaabooyinka loo adeegsado DATEVALUE ee Excel si loogu beddelo taariikhaha qaab qoraal ah oo loo beddelo lambarro taxane ah.

Sida loo isticmaalo shaqada DATEVALUE gudaha Excel^{(How to use the DATEVALUE function in Excel)}

Si aad u isticmaasho shaqada DATEVALUE gudaha Excel , raac tillaabooyinka hoose.

1. Fur Excel
2. Samee miis ama isticmaal miiska jira
3. Ku qor qaacidada shaqada DATEVALUE unuga aad rabto inaad natiijada dhigto.
4. Riix Gelida si aad u aragto natiijada

Bilaw Microsoft Excel .

Samee miis ama isticmaal miiska jira.

Ku qor shaqada   =DATEVALUE(“3/11/2021”) gudaha unugga aad rabto inaad natiijada dhigto.

Kadib riix furaha geli si aad u aragto natiijada.

Si ka duwan hawlaha kale ee aad riixi karto unugga, tirada unugyaduna waxay ka muuqan doontaa qaacidada, shaqadan, waa inaad ku qortaa taariikhda (kor lagu muujiyey), haddii kale waxay soo celin doontaa qalad #VALUE ah.

Fadlan samee wax la mid ah taariikhaha kale ee qolka dhexdiisa si aad u hesho natiijooyinkooda.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada DATEVALUE gudaha Excel .

Habka koowaad waa inaad gujiso badhanka fx ee bidix ee sare ee xaashida shaqada ee Excel .

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada-hadalka ee qaybta, Dooro Qaybta^{(Select a Category)} , ka dooro taariikhda iyo wakhtiga^{(Date and Time )} sanduuqa liiska.

Qaybta Dooro Shaqo^{(Select a Function)} , ka dooro hawsha DATEVALUE liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Qaybta Date_text , geli sanduuqa gelitaanka “3/11/2021” .

Kadib dhagsii OK .

Habka labaad waa in aad gujiso Formulas tab oo aad gujiso taariikhda iyo wakhtiga^{(Date and Time )} badhanka ee kooxda maktabadda Function^{(Function Library)} .

Liiska, ka dooro DATEVALUE.

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Waa maxay sababta DATEVALUE u soo celiso #VALUE?

# VALUE waa qiyam qalad ah gudaha ^(Error)Excel ; Shaqada DATEVALUE waxay soo celin doontaa # VALUE haddii unuggu aanu ku jirin taariikh loo qaabeeyey qoraal ahaan haddii xogta la geliyey ay ka baxsan tahay xadka, DATEVALUE waxay soo celin doontaa khaladka # VALUE .

Waxaan rajeyneynaa in casharkan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada DATEVALUE ee Excel ; haddii aad wax su'aalo ah ka qabto casharrada, noogu soo sheeg faallooyinka.

How to use the DATEVALUE function in Excel

DATEVALUE is a Date and Time function, and its purpose is to convert a date in the form of text to a serial number. In this post, we will show you how to use the DATEVALUE function in Microsoft Excel.

What is the syntax and formula for Excel DATEVALUE function?

The formula for the DATEVALUE function is DATEVALUE(date_text).

The syntax for the DATEVALUE function is:

Date_text: Text that represents a date in a date format. It is required.

How do I use DATEVALUE in Excel?

The DATEVALUE function is easy to do; you have to know the formula. This tutorial will discuss steps to use the DATEVALUE function in Excel to convert dates in a text format to serial numbers.

How to use the DATEVALUE function in Excel

To use the DATEVALUE function in Excel, follow the steps below.

1. Launch Excel
2. Create a table or use an existing table
3. Type the formula for the DATEVALUE function into the cell you want to place the result.
4. Press Enter to see the result

Launch Microsoft Excel.

Create a table or use an existing table.

Type the function  =DATEVALUE(“3/11/2021”) into the cell you want to place the result.

Then press the enter key to see the result.

Unlike the other functions that you could click the cell, and the cell range will show up in the formula, with this function, you have to type the date out (shown above), or else it will return a #VALUE error.

Please do the same thing for the other dates within the cell to get their results.

There are two other methods to use the DATEVALUE function in Excel.

Method one is to click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Date and Time from the list box.

In the section Select a Function, choose the DATEVALUE function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the Date_text section, input into the entry box “3/11/2021”.

Then click OK.

Method two is to click the Formulas tab and click the Date and Time button in the Function Library group.

From the list, select DATEVALUE.

A Function Arguments dialog box will appear.

Why does DATEVALUE return #VALUE?

#VALUE is an Error value in Excel; the DATEVALUE function will return an #VALUE if the cell does not contain a date formatted as text if the data entered is outside the range, the DATEVALUE will return the error #VALUE.

We hope this tutorial helps you understand how to use the DATEVALUE function in Excel; if you have questions about the tutorial, let us know in the comments.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel