IF statements with dates and criteria
Solved/Closed
                    
        
                    jimbabama
    
        
                    Posts
            
                
            2
                
                            Registration date
            Monday November  7, 2016
                            Status
            Member
                            Last seen
            November  7, 2016
            
                -
                            Nov  7, 2016 at 06:20 PM
                        
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 8, 2016 at 06:00 AM
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 8, 2016 at 06:00 AM
        Related:         
- Different dates of "end to end encryption message" on blank chat?
- Encryption And Decryption - Download - Encryption and decryption
- Voice message downloader - Guide
- How to update dates in Excel spreadsheet: formula - Guide
- Message request on instagram disappeared - Guide
- Sophos free encryption - Download - Encryption and decryption
2 responses
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Nov 7, 2016 at 06:52 PM
    Nov 7, 2016 at 06:52 PM
                        
                    jimbabama, Good evening. 
 
Try to use:
C1 --> =IF(A1=B1, B1, B1+14)
Format A, B and C cells as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
            Try to use:
C1 --> =IF(A1=B1, B1, B1+14)
Format A, B and C cells as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Nov 8, 2016 at 06:00 AM
    Nov 8, 2016 at 06:00 AM
                        
                    Thanks for the feedback.
Glad to be of help!
--
Belo Horizonte, Brasil.
Marcílio Lobão
            Glad to be of help!
--
Belo Horizonte, Brasil.
Marcílio Lobão
 
        
    
    
    
    
Nov 7, 2016 at 08:10 PM