date - Google表格，如果日期小于今天+30(Google sheets if date is less than today +30)

Question

I have a date field cell (using data validation), I want to turn that cell red ( A14 ) if the date entered is less than 30 days from that date to the date in 30 days time ( today()+30 ).

(我有一个日期字段单元格（使用数据验证），如果输入的日期从该日期到30天时间内的日期（ today()+30 ） 少于 30天，我想将该单元格变成红色（ A14 ）。)

=if(A14<today()+30, A14>today())

If A14's date is less than the date in 30 days and greater than today's date, then it would fall within the next 30 days.

(如果A14的日期小于30天的日期且大于今天的日期，则它将在接下来的30天内。)

Therefore the cell should turn red.

(因此，单元格应该变成红色。)

I tried the above and it doesn't work.

(我尝试了上述方法，但不起作用。)

I noticed the date output of the date field was using dashes (01-01-2020) and today() was slashes (01/01/2020), so I formatted the date cell to reflect slashes too, but still it doesn't work.

(我注意到date字段的日期输出使用破折号（01-01-2020）， today()是斜杠（01/01/2020），所以我也格式化了日期单元格以反映斜杠，但仍然没有工作。)

  ask by GoldenGonaz translate from so

Answer 1

简单尝试：

=(A14<TODAY()+30)*(A14>TODAY())