(C) 2012 - 2017 by Mourad Louha · All rights reserved.

Date and time functions

DATE

Categories: Date & Time, Functions
Comments: No

Description

The description for the function DATE is not available yet.

Availability

The DATE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003YesDate & Time

Syntax

DATE(Year,Month,Day)

Arguments

The DATE has the following arguments. Required arguments are bold.

DesignationDescription
Year
Month
Day

 


Description

The description for the function DATEVALUE is not available yet.

Availability

The DATEVALUE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003YesDate & Time

Syntax

DATEVALUE(Date_text)

Arguments

The DATEVALUE has the following arguments. Required arguments are bold.

DesignationDescription
Date_text

 


DAY

Categories: Date & Time, Functions
Comments: No

Description

The description for the function DAY is not available yet.

Availability

The DAY function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003YesDate & Time

Syntax

DAY(Serial_number)

Arguments

The DAY has the following arguments. Required arguments are bold.

DesignationDescription
Serial_number

 


DAYS

Categories: Date & Time, Functions
Comments: No

Description

The description for the function DAYS is not available yet.

Availability

The DAYS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010No
Excel 2007No
Excel 2003No

Syntax

DAYS(End_date,Start_date)

Arguments

The DAYS has the following arguments. Required arguments are bold.

DesignationDescription
End_date
Start_date

 


Description

The description for the function DAYS360 is not available yet.

Availability

The DAYS360 function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003YesDate & Time

Syntax

DAYS360(Start_date,End_date,Method)

Arguments

The DAYS360 has the following arguments. Required arguments are bold.

DesignationDescription
Start_date
End_date
Method

 


Description

The description for the function EDATE is not available yet.

Availability

The EDATE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003No

Syntax

EDATE(Start_date,Months)

Arguments

The EDATE has the following arguments. Required arguments are bold.

DesignationDescription
Start_date
Months

 


Description

The description for the function EOMONTH is not available yet.

Availability

The EOMONTH function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003No

Syntax

EOMONTH(Start_date,Months)

Arguments

The EOMONTH has the following arguments. Required arguments are bold.

DesignationDescription
Start_date
Months

 


HOUR

Categories: Date & Time, Functions
Comments: No

Description

The description for the function HOUR is not available yet.

Availability

The HOUR function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesDate & Time
Excel 2010YesDate & Time
Excel 2007YesDate & Time
Excel 2003YesDate & Time

Syntax

HOUR(Serial_number)

Arguments

The HOUR has the following arguments. Required arguments are bold.

DesignationDescription
Serial_number

 

 
Top