Hi. I am not good with formulas and need help writing this one. It pertains to date calculations if less than 30 days, 30-60 days, or greater than 60 days
What I am looking for is if Field O2 is >0 show"Ignore", if O2 is <0, then proceed to subtract Today's date from the start date field. If date calculation is <30 days, show < 30 days. If date calculation is between 30-60 days, show 30-60 days. If the date calculation >60 days, show >60 days.
Any help with this will be appreciated.
What I am looking for is if Field O2 is >0 show"Ignore", if O2 is <0, then proceed to subtract Today's date from the start date field. If date calculation is <30 days, show < 30 days. If date calculation is between 30-60 days, show 30-60 days. If the date calculation >60 days, show >60 days.
Any help with this will be appreciated.