Hi All! I’m trying to calculate a formula for conditional formatting. I’m sure this is easy, but what I tried isn’t working. I already have a row that calculates # of days between dates (Today()-thisRow.[Trial Start Date]), but I want to color-code based on duration. For example, I want: <45 days …

You’re probably overthinking it trying to pack it all into one complex statement :slight_smile: Join 2 statements with AND thisRow.[Trial Duration] >= 45 AND thisRow.[Trial Duration] <= 90

Formula Help - calculating "between" dates

Nick_HE March 2, 2022, 5:04pm 2

You’re probably overthinking it trying to pack it all into one complex statement
Join 2 statements with AND

thisRow.[Trial Duration] >= 45 AND thisRow.[Trial Duration] <= 90

2 Likes

Topic		Replies	Views
Conditional format between times	5	598	September 4, 2022
Given a start date and end date, how do you calculate duration?	3	981	September 6, 2023
Conditional formatting between changing time values	1	537	May 11, 2020
Help with Dates	2	551	August 31, 2019
Conditional Format when "Due Date" is 2 or 1 or 0 days later than TODAY	10	2062	January 13, 2024

Formula Help - calculating "between" dates

Related topics