Thread: [Solved] stop date calculation when a criteria is met
View Single Post
 
Old 12-12-2018, 09:30 AM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
You calculate time difference in days? So include it into MAX() function (or MIN(), depending on sign of calculated difference). Something like
Code:
=MAX(Date2-Date1, 30)
Reply With Quote