#1
|
||||
|
||||
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. |
#2
|
||||
|
||||
Try the following applied to C2:C10
=AND($A1=$A2,$B1=$B2,DATEDIF($C1,$C2,"m")<9)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
=AND($A1=$A2,$B1=$B2,DATEDIF($C1,$C2,"m")<9)[/QUOTE]
Thank you! Pecoflyer. I changed the $B1=$B2 to $B1="C" This formula validates birthdates of siblings. We were told that parents and children's bdates in the database should not be less that 8 yrs difference. Who gives birth at 8 yrs old? Horror!! |
#4
|
||||
|
||||
You're welcome
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
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 |