Date Diff Formula Help
I have a table with 3 columns - RequestID, Customer Last Response, Technician Last Response. I need help creating a formula that will display the amount of days that have passed since a technician last responded to the customer.
So if the technician has the most recent reply it should display 0.
If the customer has the most recent reply it should show the number of days that have gone by to date since they last replied. So for example if the customer has the most recent reply and they replied on Jan 3 at 8am and the report is run at Jan 4 at 8am it would display 1.
Thanks much
So if the technician has the most recent reply it should display 0.
If the customer has the most recent reply it should show the number of days that have gone by to date since they last replied. So for example if the customer has the most recent reply and they replied on Jan 3 at 8am and the report is run at Jan 4 at 8am it would display 1.
Thanks much
Topic Participants
Brian Sokol
Rakesh
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?