View Single Post
 
Old 05-21-2020, 01:06 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

=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!!
Reply With Quote