Blog

• Ben Collins - Google sheet guru

Useful functions/tips/tricks

Import data from other sheet

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1vNUpW8r1cQd-kPZ21220Lg5yejlGNGP9W6eiVZ_6Hal0cE"; "Master!A2:B3")

Get last non empty value in a column

=INDIRECT("A"&COUNTA(A:A))

Reference: https://stackoverflow.com/questions/8116043/get-the-last-non-empty-cell-in-a-column-in-google-sheets

Autofill weekdays only

# A2: Fill first day
# A3

= A2 + IF(WEEKDAY(A2)>5;3;1)
# If A2 is Fridays, add 3 days, other, add 1 days

Reference: https://stackoverflow.com/a/42895909/4381022