MFish
Board Regular
- Joined
- May 9, 2019
- Messages
- 76
Hello,
My first tab is just a very basic calendar that shows the days of the month and the numbered days. The calendar should read the second tab with accounts that have a "frequency" column. The frequency column will say, Monday, Wednesday, Friday or Every 10 days or daily, etc. (Can be different schedules).
I'd like for the calendar to auto read the frequency and "place" the name of the account in that said day. I don't know if this will throw a loop in the whole thing, but I do not have my company work on the weekends, so if it says every 10 days and the 10th day happens to be on a Saturday, it should be automatically placed on the Friday, instead. If it lands on a Sunday, it populates on Monday, instead.
Thanks.
My first tab is just a very basic calendar that shows the days of the month and the numbered days. The calendar should read the second tab with accounts that have a "frequency" column. The frequency column will say, Monday, Wednesday, Friday or Every 10 days or daily, etc. (Can be different schedules).
I'd like for the calendar to auto read the frequency and "place" the name of the account in that said day. I don't know if this will throw a loop in the whole thing, but I do not have my company work on the weekends, so if it says every 10 days and the 10th day happens to be on a Saturday, it should be automatically placed on the Friday, instead. If it lands on a Sunday, it populates on Monday, instead.
Thanks.