Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Where the red cells are how would I add to this so that it doesnt include when there is not a date in J8 etc,
Where the red cells are how would I add to this so that it doesnt include when there is not a date in J8 etc, Thank you
AutoSave On A CherylHumphrey_FinalProject... - Saved Search (Alt+Q) Cheryl Humphrey CH X File Home Insert Page Layout Formulas Data Review View Help Share Comments fx E ... Define Name Trace Precedents fx Show Formulas Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Use in Formula "Trace Dependents x Error Checking Watch Calculation Function Used Time ~ Reference Trig Functions Manager Create from Selection FX Remove Arrows Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation K3 X V fix ="[Dog Breeding.xIsx]Breeding Record"!$13-'[Dog Breeding.xIsx]Breeding Record"!$13 A B C D E G H K L M N O P Q 2 Female Stud 1st date in heat arrived at stud Date Ist bred Days in Heat Date last bred Comments Date Due Date whelped + or - Result 8 Weeks # Pups 3 Emma Bear 7/8/2021 7/15/2021 7 9/16/2021 9/19/2021 3 |Goo 11/14/2021 13 4 Emma Bea 1/8/2021 1/16/2021 8 3/20/2021 3/21/2021 1 Good 5/16/2021 LO 5 Bea 7/1/2020 7/11/2020 10 9/12/2020 9/9/2020 -3 No 11/4/2020 8 6 Emma Bear 12/23/2019 1/1/2020 9 3/4/2020 3/2/2020 .2 No 4/27/2020 Good 8 Hope Caleb 9/4/2021 9/10/2021 9/11/2021 11/13/2021 -44513 Good 9 0 Good 10 Joy Bear 8/8/2021 8/16/2021 10/18/2021 -44487 Good 11 Joy Bear 1/25/2021 3/29/2021 3/27/2021 -2 No 5/22/2021 12 0 Good 13 Katy Caleb 9/16/2021 9/18/2021 9/24/2021 Al Caleb 11/26/2021 -44526 Good 14 Katy Caleb 2/20/2021 2/27/2021 2/28/2021 3/8/2021 Al cover Stirling 5/2/2021 4/28/2021 4 No 6/23/2021 15 Katy Stirling 7/29/2020 8/6/2020 8/8/2020 8/9/2020 10/10/2020 10/5/2020 5 No 11/30/2020 16 6 00 0 0 00 00 0 Good 17 Snip Burbon 6/10/2021 6/18/2021 8/20/2021 8/21/2021 0 Good 10/16/2021 18 Snip Burbon 1/5/2021 1/12/2021 3/16/2021 3/17/2021 0 Good 5/12/2021 19 Snip Burbon 5/25/2020 6/4/2020 8/6/2020 8/2/2020 0 Good 9/27/2020 20 o 0 21 22 o 23 24 25 o 26 27 28 Breeding Record + Ready + 120% Type here to search O Ei X W 2 58 F Mostly clear ~ 9 () 7:58 PM 10/7/2021Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started