Skip to main content

Google Sheets: Notes

"Google Sheets is a web-based application that enables users to create, update and modify spreadsheets and share the data online in real time." — TechTarget

>>> To create a new worksheet, access https://sheets.google.com/new

>>> Calculate number of days, months, or years between two dates

=DATEDIF(start_date; end_date; unit)

DATE DIFFERENCE: Calculates the number of days, months, or years between two dates.
start_date: from date
end_date: to date
unit: DAY, MONTH, YEAR...

>>> Get value from "Price" sheet, 'N2' cell.

var cellValue = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Price").getRange('N2').getValue();
// Logger.log(cellValue);

>>> GOOGLEFINANCE function: https://spreadsheetpoint.com/googlefinance-function-guide/

>>> IMPORTHTML: Imports data from a table or list within an HTML page.

>>> CANNOT DIRECTLY insert special characters in Google Sheets, but CAN copy & paste special characters.

Popular posts from this blog

nmap - The Network Mapper

WARNING : It is ILLEGAL to scan hosts without permission.

GitHub CLI

GitHub CLI brings GitHub to your terminal. Free and open source. Official website: https://cli.github.com

Microsoft Windows Server 2003 R2 Enterprise Edition VHD

Windows Server 2003 R2 Enterprise Edition with Service Pack 2 This download comes as a pre-configured VHD and helps you evaluate the new features of Windows Server 2003 R2, the most productive infrastructure platform for powering connected applications, networks, and Web services from the workgroup to the data center. https://www.microsoft.com/en-us/download/details.aspx?id=19727 Username: Administrator Password: Evaluation1