Create a Google Spreadsheet where I can enter/edit my international travel dates, and have it automatically calculate the # of days spent in each country.
One key feature is that the spreadsheet needs to look at the rolling 12-month total for days spent in each country, in addition to the annual tax year days spent in each country, and show an alert if the # of days exceed a set target.
This will be used for forward-looking date planning in addition to tracking past travels, so it needs to be easy to try out "what if" scenarios where I experiment with different travel plans/dates to avoid exceeding the set target.
I have an existing template to show what I'm thinking of in how the data could be presented.
29 freelancers are bidding on average $6/hour for this job
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards