Calculating number of weekdays/weekend days

[Kip]

Dear all,

 

 

I am running a b&b and run into the following issue. I have a calendar with a check in date and a calendar with a check out date.

The period of time selected into these calendars should result into the following:

1) number of weekend days (whereas weekend days are definable i.e. friday/saturday or saturdays/sundays)

2) number of work days (also definable: ie weekdays can be defined starting on either sunday or mondays)

3) a total of nights stayed. (check in date - minus check out date)

 

I can't seem to find the way to calculate 1 and 2 and how to set this up.

 

Anybody knows the trick for this?

 

Thanks in advance.

 

[eos]

1) number of weekend days (whereas weekend days are definable i.e. friday/saturday or saturdays/sundays)

2) number of work days (also definable: ie weekdays can be defined starting on either sunday or mondays)

 

Where 2) follows from 1), I take it …?

 

See if the attached file can help you.

 

Note that you need to store the weekend day selection with the individual reservation, because if this was a global setting, existing reservations could/might/would be falsified by later changes. You can of course use a global (maybe seasonal?) selection and use this as an auto-enter value.

 

Adjust/use alert and CF colors/messages as you see fit.

WeekendDays_eos.fp7.zip

[Kip]

Brilliant! This did the trick. Thanks so much.