Skip to content

Instantly share code, notes, and snippets.

@fedir

fedir/WeekNumber&FridayDate

Created August 26, 2015 10:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fedir/fa1257a502027620d768 to your computer and use it in GitHub Desktop.
Save fedir/fa1257a502027620d768 to your computer and use it in GitHub Desktop.
Download ZIP
WeekNumber & Las Week Working Day (Friday) in Google Spreadsheet
Raw
WeekNumber&FridayDate
=7*C2+DATE(2015;1;1)-(8-WEEKDAY(date(O4;1;1)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment