Click the "allow" button if you want to receive important news and updates from Immigration, work visa and work permit discussion board

Welcome to!

Login Register Do not show

New Google Docs spreadsheet template for days out of country

Please use this section of the board for queries about Indefinite Leave to Remain (ILR). However please use the EEA-route section for queries about the EEA-route equivalent of Permanent Residence (PR).

This section is relevant irrespective of whether current status is Tiered or Non-Tiered.

Moderators: Casa, push, JAJ, ca.funke, Amber, Zimba, vinny, Obie, EUsmileWEallsmile, batleykhan, geriatrix, John, ChetanOjha, archigabe

Newly Registered
Posts: 11
Joined: Wed Oct 10, 2012 12:27 pm

New Google Docs spreadsheet template for days out of country

Post by BobSteel » 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.