Proper calc to get amount of days from a given date like Project Kickoff Date - 30

Are you trying to find out the number of days between the current date and 30 days before the field date?

It sounds like you need a combination of DATEADD(), DATETIME_DIFF() and TODAY()

You may need to play around with the order of things, but here is a starting point.

DATETIME_DIFF(
  DATEADD(
    {Project Kickoff Date},
    -30,
    "days"
  ),
  TODAY(),
  "days"
)

DATETIME_DIFF(
  DATEADD(
    {Project Kickoff Date},
    -30,
    "days"
  ),
  TODAY(),
  "days"
)

No, 2 project dates…Kickoff Date and Connectivity Date and if greater than 30 days, show Red, if less than 30 days show Green…how to do that? Kickoff Date and Connectivity Date already exist as fields in my airtable.

Thank you for the extra clarification. Do you want something like this:

IF(
  DATETIME_DIFF({Connectivity Date}, {Project Kickoff Date}, 'days') > 30,
  "red",
  "green"
)

IF(
  DATETIME_DIFF({Connectivity Date}, {Project Kickoff Date}, 'days') > 30,
  "red",
  "green"
)

Hello,

So here is the formula that works for our needs:

DATETIME_DIFF({Connectivity},{Project Kickoff},‘days’)-30 so while this is great, there’s more…

What I need help with now is on each individual column to make the color change and there are 5 different columns and negatives should be green as they are under threshold and positives should be red as over threshold.

Thanks,