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

Date and time functions

Description

The description for the function TIMEVALUE is not available yet.

Availability

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

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

Syntax

TIMEVALUE(Time_text)

Arguments

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

DesignationDescription
Time_text

 


Description

The description for the function TODAY is not available yet.

Availability

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

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

Syntax

TODAY()

Arguments

The TODAY function has no arguments.

 


Description

The description for the function WEEKDAY is not available yet.

Availability

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

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

Syntax

WEEKDAY(Serial_number,Return_type)

Arguments

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

DesignationDescription
Serial_number
Return_type

 


Description

The description for the function WEEKNUM is not available yet.

Availability

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

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

Syntax

WEEKNUM(Serial_number,Return_type)

Arguments

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

DesignationDescription
Serial_number
Return_type

 


Description

The description for the function WORKDAY is not available yet.

Availability

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

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

Syntax

WORKDAY(Start_date,Days,Holidays)

Arguments

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

DesignationDescription
Start_date
Days
Holidays

 


Description

The description for the function WORKDAY.INTL is not available yet.

Availability

The WORKDAY.INTL function is available in the following Microsoft Excel versions.

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

Syntax

WORKDAY.INTL(Start_date,Days,Weekend,Holidays)

Arguments

The WORKDAY.INTL has the following arguments. Required arguments are bold.

DesignationDescription
Start_date
Days
Weekend
Holidays

 


YEAR

Categories: Date & Time, Functions
Comments: No

Description

The description for the function YEAR is not available yet.

Availability

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

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

Syntax

YEAR(Serial_number)

Arguments

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

DesignationDescription
Serial_number

 


Description

The description for the function YEARFRAC is not available yet.

Availability

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

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

Syntax

YEARFRAC(Start_date,End_date,Basis)

Arguments

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

DesignationDescription
Start_date
End_date
Basis

 

 
Top