Hide rows based on Datediff

[Blanchetdb]

I need some help combining both. I have two cells where dates are entered, so if the difference between both dates is greater than 6 months then rows 71:73 unhide......

 

[Trebor76]

Try this while on the sheet in question where the dates are in cells A2 and B2 (change to suit):

Option Explicit
Sub Macro3()

    If Evaluate("DATEDIF(A2,B2,""M"")") > 6 Then
        Application.ScreenUpdating = False
            Rows("71:73").Hidden = False
        Application.ScreenUpdating = True
    End If

End Sub

HTH

Robert

 

[Blanchetdb]

Unfortunately it didn't work.....do the dates have to be in a specific format? I presently have the dates as yyyy-mm-dd

I also tried this but nothing

Sub Macro3()
If Evaluate("DATEDIF(H68,K68,""M"")") > 6 Then
Worksheets("Sheet1").Range("73:75").EntireRow.Hidden = True
Else
Worksheets("Sheet1").Range("73:75").EntireRow.Hidden = False
End If
End Sub

 

[MARK858]

The code you posted works fine for me.

Do you get any errors (if yes what exactly does it say)?
Is the date in H68 before the date in K68?
If you put in empty cells the formulas

=ISNUMBER(H68)

and

=ISNUMBER(K68)

do you get TRUE or FALSE for the results of both formulas?
Are H68 and K68 both on Sheet1 and is Sheet1 active when running the code?

 

[Blanchetdb]

H68 has an earlier date than K68.....and they are both on Sheet1 which is the active sheet

 

[MARK858]

....and the answer to the other 2 questions is......?

 

[Blanchetdb]

no and no......nothing happens

 

[MARK858]

What the 2 formulas produce no and not TRUE or FALSE?

 

[Blanchetdb]

I just got it to work.....inserted the macro in another sub that was doing other hiding functions

thank you

 

[Blanchetdb]

encountered another problem ....how can get the datedif to calculate > 6 months exactly base on the days and the month.

example: 2108-04-15 and 2018-10-27.....I need that to trigger greater than 6 months. Right now it only calculates based on the month