New Google Docs spreadsheet template for days out of country
Posted: Mon Oct 15, 2012 3:35 pm
I put this together for my own application, so I thought I'd share it with the rest of the forum.
Please click File -> Make a Copy before you edit! I had to leave it editable to allow others to save it and see the forumulas.
Add a line for each day out of the country. It's easy to add lots of lines, then change the date to the above cell +1 if you have lots of trips.
Just make sure the text field is the same for the entire trip if you want the "full days" to calculate correctly. Otherwise overwrite that column.
Enjoy.
Please click File -> Make a Copy before you edit! I had to leave it editable to allow others to save it and see the forumulas.
Add a line for each day out of the country. It's easy to add lots of lines, then change the date to the above cell +1 if you have lots of trips.
Just make sure the text field is the same for the entire trip if you want the "full days" to calculate correctly. Otherwise overwrite that column.
Enjoy.