|
|
#3
05-21-2020, 01:06 AM
|
||||
|
||||
=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!! 
|
| 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