If Then rule with dates help
Closed
                                    
                        Valkrie                    
                                    -
                            Sep 18, 2015 at 04:59 PM
                        
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 18, 2015 at 07:40 PM
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 18, 2015 at 07:40 PM
        Related:         
- If Then rule with dates help
 - Apple iphone 13 release dates - Guide
 - Outlook rule not working - Guide
 - If function with dates - Guide
 - Annual mileage calculator with odometer dates ✓ - Excel Forum
 - Different dates of "end to end encryption message" on blank chat? - Excel Forum
 
1 response
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Sep 18, 2015 at 07:40 PM
    Sep 18, 2015 at 07:40 PM
                        
                    Valkrie, Good evening.
Suppose your date is at A1.
B1 -->
=IF(WEEKDAY(A1+84,2)=7,A1+84;A1+84+7-WEEKDAY(A1+84,2))
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
            Suppose your date is at A1.
B1 -->
=IF(WEEKDAY(A1+84,2)=7,A1+84;A1+84+7-WEEKDAY(A1+84,2))
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão