[Dba-office] Help figuring out the Best Approach To Take

Bryan Carbonnell carbonnb at gmail.com
Tue Mar 29 13:47:54 CDT 2016


I hope I can explain what I'm trying to do properly.

Let me give you some background so you understand what I'm up against.

As a Canadian I can only be in the US for 182 days in the past 365
days. This 365 days is a rolling 365 days and not a calendar year. So
for today it is 182 days from March 30, 2015 to Mar 29, 2016. Tomorrow
it would be 182 days from Mar 31, 2015 to Mar 30, 2016 etc.

I was thinking of using Excel, one column for each year, each row for
a different day of the year and putting either a C or U to denote
which country I'm in.

Then having a cell at the top that counts all the U or C in the
previous 365 days.

However I'm not sure how to go about this.

Oh, and I have to keep 4 years of records to stay out of trouble with the IRS.

I'm hoping the brain power here can help me figure this out.

Thanks for any suggestions or pointers. Oh, Access is NOT an option.
I'm on a Mac.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a
well-preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"


More information about the Dba-office mailing list