Expenses greater than 90 days

[AnnaO]

I have a pretty large spread sheet that shows expenses for a quarter. On the spreadsheet there’s the date each expense was incurred and the date it was approved. I’m trying to isolate the expenses that were approved more than 3 months after they were incured (>90 days). Is there a formula I can use to calculate this? Thanks in advance for your help!

 

[Joe4]

Welcome to the Board!

Are you trying to total the expenses greater than 90 days?
If so, you should be able to do so with a SUMIF formula.
See: https://exceljet.net/excel-functions/excel-sumif-function

 

[Logit]

.
Assuming the beginning dates are in Col A ... ending dates are in Col B ... and the difference is in Col C :

Option Explicit


Sub FilterDescription()


Dim strName As String
Dim range_to_filter As Range
On Error Resume Next
Set range_to_filter = Range("C2:C20")


Application.ScreenUpdating = False
Range("A1:C1").Select
    Selection.AutoFilter
    range_to_filter.AutoFilter Field:=3, Criteria1:=">30"
    Range("A1").Select
Application.ScreenUpdating = True


End Sub


Sub Clear_All_Filters_Range()
On Error Resume Next
  
  Application.ScreenUpdating = False
    Sheet1.ShowAllData
    ActiveSheet.AutoFilterMode = False
  Application.ScreenUpdating = True
  
End Sub