Hi ,
You have 4 sections to your output area :
Fresh Date
Dry Date
70 days
35 days
Starting from the top , the relationship between these dates is :
Fresh Date > Dry Date > 70 days > 35 days
Thus , if you want that an entry should appear only in one section at any time , then the checking should always check two sections , the section you are interested in , and the next higher section.
Thus , for the 35 days section , you need to check for the 35 days date and the 70 days date , as follows :
=IF(dateincolumnA > 70 days date ,"" , if(dateincolumnA > 35 days date, cow number, ""))
For the 70 days section , you need to check for the 70 days date and the Dry Date , as follows :
=IF(dateincolumnA > Dry Date ,"" , if(dateincolumnA > 70 days date, cow number, ""))
For the Dry Date section , you need to check for the Dry Date and the Fresh Date , as follows :
=IF(dateincolumnA > Fresh Date ,"" , if(dateincolumnA > Dry Date, cow number, ""))
For the Fresh Date section , you need to check only for the Fresh Date , as follows :
=IF(dateincolumnA > Fresh Date ,cow number, ""))
See the attached file and comment.
Narayan