Compare and return the oldest date
Closed
                    
        
                    McEgirl-J
    
        
                    Posts
            
                
            1
                
                            Registration date
            Saturday February  8, 2014
                            Status
            Member
                            Last seen
            February  8, 2014
            
                -
                            Feb  8, 2014 at 12:24 PM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Feb 10, 2014 at 11:48 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Feb 10, 2014 at 11:48 AM
        Related:         
- Compare and return the oldest date
 - "Compare versions word" - Guide
 - Beyond compare download - Download - File management
 - Thunderbird return receipt - Guide
 - How to Compare two workbooks and see if data has moved or not? - Excel Forum
 - Display two columns in data validation list but return only one - Guide
 
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Feb 10, 2014 at 11:48 AM
    Feb 10, 2014 at 11:48 AM
                        
                    Hi McEgirl-J,
The formula MAX will pick the highest value (or date) within a given range.
Give it a try.
Best regards,
Trowa
 
                
                
            The formula MAX will pick the highest value (or date) within a given range.
Give it a try.
Best regards,
Trowa