Function Name

DAY

Syntax

DAY(number)

Description

Returns the day, as an integer, of the given date value. A negative date/time value can be entered. Number is a time value.

Example:

=DateValue("31/01/2013") = 41305

Google Day Function Example

	A	B
1	Date	41305
2	Formula	=Day(B1)
3	Result	31

Google Spreadsheet Function - DATEVALUE

Function Name

DATEVALUE

Syntax

DATEVALUE(text)

Description

Returns the internal date number for text in quotes. Text is a valid date expression and must be entered with quotation marks.

Example:

Google DateValue Function Example

	A	B
1	Formula	=DateValue("31/01/2013")
2	Result	41,305

Google Spreadsheet Function - DATE

Function Name

DATE

Syntax

DATE(year, month, day)

Description

Converts a date written as year, month, day to an internal serial number and displays it in the cell's formatting. Year is an integer between 1583 and 9956 or 0 and 99. Month is an integer between 1 and 12. Day is an integer between 1 and 31.

Example:

Google Date Function Example

	A	B
1	Date	11/01/2013 11:05:10
2	Formula	=Date(Year(B1),Month(B1),Day(B1))
3	Result	11/01/2013

Sending Ctrl + Alt + Del to Remote Client in Remote Desktop Connection Session

If you press Ctrl + Alt + Del while using Remote Desktop Connection, your local PC will response to the key pressed rather then the remote PC.

In order to send Ctrl-Alt-Del keystrokes to remote computer connected via Remote Desktop Client, just press Ctrl + Alt + End.