thanksamillion101
New Member
- Joined
- Jul 8, 2020
- Messages
- 41
- Office Version
- 2010
Good Morning all!,
For each client profile, there is specified field that shows scheduled appointment months when I run our monthly report. Ex. A2 Client Name B2 Jul C2 Jan/Apr/Jul/Oct D2 1/15/22
If I am doing the scheduling for July, and the last appointment date is 1/15/22, then an "X" should return in G2 because there was no appointment date for April.
Using tables, I thought would be the most effective, but unsure of the formula. Please help!
Table 1 Ex.
A2 B2
Jan
Feb Jan, Feb
Mar Jan, Feb, Mar
Apr Jan, Feb, Mar, Apr
May Jan, Feb, Mar, Apr, May
Jun Jan, Feb, Mar, Apr, May, Jun
Jul Jan, Feb, Mar, Apr, May, Jun, Jul
Table 2 Ex.
A10 B10
Jan 1/1/22
Feb 2/1/22
Mar 3/1/22
Apr 4/1/22
May 5/1/22
Jun 6/1/22
Jul 7/1/22
For each client profile, there is specified field that shows scheduled appointment months when I run our monthly report. Ex. A2 Client Name B2 Jul C2 Jan/Apr/Jul/Oct D2 1/15/22
If I am doing the scheduling for July, and the last appointment date is 1/15/22, then an "X" should return in G2 because there was no appointment date for April.
Using tables, I thought would be the most effective, but unsure of the formula. Please help!
Table 1 Ex.
A2 B2
Jan
Feb Jan, Feb
Mar Jan, Feb, Mar
Apr Jan, Feb, Mar, Apr
May Jan, Feb, Mar, Apr, May
Jun Jan, Feb, Mar, Apr, May, Jun
Jul Jan, Feb, Mar, Apr, May, Jun, Jul
Table 2 Ex.
A10 B10
Jan 1/1/22
Feb 2/1/22
Mar 3/1/22
Apr 4/1/22
May 5/1/22
Jun 6/1/22
Jul 7/1/22