thanksamillion101
New Member
- Joined
- Jul 8, 2020
- Messages
- 41
- Office Version
- 2010
Hello, Thank you in advance!!
I have a spreadsheet that I need a formula to find latest month in the first range (abbreviated month) and calculate if the latest date in another range (date by month) is greater or equal to the first range (latest abbrev month). The formula will help determine if an appointment has been missed and return "Name" if latest date is not in this year. The first range indicates scheduled months and the second, indicates the latest appointment date.
I have the first portion of the formula to determine the latest month in the first range. (Formula is in AC2) I will be generating list for September.
LOOKUP(2,1/(D2:O2<>""),D2:O2) If(Max(Q2:AB2?????
cell AC2 with formula will return "P.Thomas"because Feb and Jul appt has been missed.
cell AC3 with formula will return " " because June appt was not missed.
cell AC4 with formula will return "" because although Apr appt was missed, there was an appt in May.
cell AC5 with formula will return "J.Ferri" because the next appt for this year is September's appt. and Dec not yet due.
Hope I have explained the formula I am needing and thank you for your help!
I have a spreadsheet that I need a formula to find latest month in the first range (abbreviated month) and calculate if the latest date in another range (date by month) is greater or equal to the first range (latest abbrev month). The formula will help determine if an appointment has been missed and return "Name" if latest date is not in this year. The first range indicates scheduled months and the second, indicates the latest appointment date.
A | C | D | E | F | G | H | I | Jul | K | L | M | N | O | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |||
1 | Name | Latest Date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
2 | P.Thomas | 2/1/21 | Feb | Jul | 2/1/21 | |||||||||||||||||||||||
3 | K.Lymon | 6/8/22 | Jun | 6/8/22 | ||||||||||||||||||||||||
4 | S.Kay | 4/3/22 | Apr | 5/3/22 | ||||||||||||||||||||||||
5 | J.Ferri | 6/1/21 | Mar | Jun | Sep | Dec | 3/1/22 | 6/1/22 | 9/3/21 | 12/15/21 | ||||||||||||||||||
6 | P.Lena | 6/8/21 | Jun | 6/8/21 | ||||||||||||||||||||||||
7 | K.Henry | 8/3/22 | Aug | 9/3/22 |
I have the first portion of the formula to determine the latest month in the first range. (Formula is in AC2) I will be generating list for September.
LOOKUP(2,1/(D2:O2<>""),D2:O2) If(Max(Q2:AB2?????
cell AC2 with formula will return "P.Thomas"because Feb and Jul appt has been missed.
cell AC3 with formula will return " " because June appt was not missed.
cell AC4 with formula will return "" because although Apr appt was missed, there was an appt in May.
cell AC5 with formula will return "J.Ferri" because the next appt for this year is September's appt. and Dec not yet due.
Hope I have explained the formula I am needing and thank you for your help!