My company schedules services to customers based upon a fixed week and
weekday of each month, i.e.:
"1st Monday" of each month or "3rd Friday" of each month, and so on.
Every schedule excludes Sundays, but otherwise can be anywhere from 1-1
(1st Monday) through 4-6 (fourth Saturday).
If all I have is the last calendar DATE of the last service, how can I
write an excel formula to extract which week of month and day of the
week the service was actually performed? Monday must equal "1" and
Saturday must equal "6'. For all intent and purposes, we 'ignore' 5th
week-days of the month (they are not used for fixed appointments).
I've looked and tried to use all examples posted at other sites and your
website but
cannot find a series that works. I am not opposed to breaking the
action into 'steps' - just need a solution that works.
weekday of each month, i.e.:
"1st Monday" of each month or "3rd Friday" of each month, and so on.
Every schedule excludes Sundays, but otherwise can be anywhere from 1-1
(1st Monday) through 4-6 (fourth Saturday).
If all I have is the last calendar DATE of the last service, how can I
write an excel formula to extract which week of month and day of the
week the service was actually performed? Monday must equal "1" and
Saturday must equal "6'. For all intent and purposes, we 'ignore' 5th
week-days of the month (they are not used for fixed appointments).
I've looked and tried to use all examples posted at other sites and your
website but
cannot find a series that works. I am not opposed to breaking the
action into 'steps' - just need a solution that works.