When does my 60 day FP window start?

[MickeyMinnieMom]

I always use Excel to calculate. Enter my arrival date in one cell, then in another cell I create the formula for that cell, minus 180 for ADRs, and another with arrival date cell minus 60 for FP.

 

[siskaren]

60 is actually very easy to figure out - if one of the two months prior to your arrival date has 31 days, then you add 1 to your arrival date. So in the OP's example, since one of the two months has 31 days (July) then it's 15+1, which equals 16 (the month of course would be June). If both of the two months have 31 days, then add 2 - so if the arrival date is September 15, it's 15+2, which is 17 (in July).

 

[DaisyJ]

60 is actually very easy to figure out - if one of the two months prior to your arrival date has 31 days, then you add 1 to your arrival date. So in the OP's example, since one of the two months has 31 days (July) then it's 15+1, which equals 16 (the month of course would be June). If both of the two months have 31 days, then add 2 - so if the arrival date is September 15, it's 15+2, which is 17 (in July).

Or, you could do the easiest thing possible and count back 60 days on a calendar from your check in day.

 

[MickeyMinnieMom]

Or, you could do the easiest thing possible and count back 60 days on a calendar from your check in day.

Excel is way easier than either of these!

I'll post my little 4 cell spreadsheet later if anyone would like it.

 

[siskaren]

Or, you could do the easiest thing possible and count back 60 days on a calendar from your check in day.

Counting back 60 takes longer than adding 1 or 2 to a number.

 

[MickeyMinnieMom]

I always use Excel to calculate. Enter my arrival date in one cell, then in another cell I create the formula for that cell, minus 180 for ADRs, and another with arrival date cell minus 60 for FP.

https://drive.google.com/open?id=0BwwaHpE7nFDaVmd4Q2RxU2RkY2M