Excel formula which calculates start date
Closed
                    
        
                    lsolomon
    
        
                    Posts
            
                
            1
                
                            Registration date
            Friday August 31, 2012
                            Status
            Member
                            Last seen
            August 31, 2012
            
                -
                            Aug 31, 2012 at 06:37 PM
                        
ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012 - Sep 5, 2012 at 09:02 AM
        ExcelJosh Posts 12 Registration date Wednesday August 8, 2012 Status Contributor Last seen October 12, 2012 - Sep 5, 2012 at 09:02 AM
        Related:         
- Excel formula which calculates start date
- Date formula in excel dd/mm/yyyy - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Start up sound changer - Download - Customization
- Excel color formula - Guide
1 response
                
        
                    ExcelJosh
    
        
                    Posts
            
                
            12
                
                            Registration date
            Wednesday August  8, 2012
                            Status
            Contributor
                            Last seen
            October 12, 2012
            
                    
Sep 5, 2012 at 09:02 AM
    Sep 5, 2012 at 09:02 AM
                        
                    Isolomon:
I hope this helps.
=WORKDAY(start_date, -1*(SUM(range)-1))
This doesn't take into account for Holidays. You would have to list the holidays you'd like to exclude.
Good luck,
Josh
            I hope this helps.
=WORKDAY(start_date, -1*(SUM(range)-1))
This doesn't take into account for Holidays. You would have to list the holidays you'd like to exclude.
Good luck,
Josh
