|
|
#1
05-20-2020, 07:34 PM
|
||||
|
||||
Format if the age gap is less than 9 months
Hi. The sheet has 3 fields (Family No, Member and Bdate). In the birthdate, I pasted the ff formatting formula:
=AND($a$2:$a$10,$a2,$b$2:$b$10="C",$C3-$C2<9) where: Col A = Family No, Col B = Member, Col C = Bdate) The birthdate of "C"s with less than 9 months gap from the other "C"s within the family should be formatted. Kindly point out what is missing in the formula. Thank you. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Adding Months
|
TimmiAndrew | Excel | 2 | 09-16-2015 10:21 AM |
|
Is it possible to format today's date minus 12 months
|
sarabeck | Word | 1 | 07-09-2015 04:53 PM |
|
entering duration in months
|
ketanco | Project | 1 | 12-17-2014 01:09 PM |
|
chart with months
|
windseaker | Excel | 1 | 04-29-2011 11:45 PM |
| Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |
Windows 7 32bit 
Office 2013
Threaded Mode