Date formula Puzzeled
Closed
                    
        
                    mariejose2636
    
        
                    Posts
            
                
            2
                
                            Registration date
            Tuesday September 14, 2010
                            Status
            Member
                            Last seen
            September 14, 2010
            
                -
                            Sep 14, 2010 at 12:30 PM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 16, 2010 at 10:01 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 16, 2010 at 10:01 AM
        Related:         
- Date formula Puzzeled
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Sep 16, 2010 at 10:01 AM
    Sep 16, 2010 at 10:01 AM
                        
                    Hi Joe,
I don't see the logic of your formula, but it does work if you replace the C2's by B2's. But why not use just the last part like:
=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))
Best regards,
Trowa
            I don't see the logic of your formula, but it does work if you replace the C2's by B2's. But why not use just the last part like:
=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))
Best regards,
Trowa
