Formula to count days between date column and fixed date

Platform discussions Special workflows & use cases
1

I am managing tasks for an event that must be completed anywhere from a few days to a few months before the event takes place.

I want to create a formula that will count the number of days between the task due date and the fixed date of the event. So far I can’t find out what value I need to put for the formula column to recognize a fixed date instead of needing to reference a column.

I tried this basic formula but it is returning values like “45,570”, which is obviously not the correct number of days between July and September!

DAYS(
{Deadline}, (09/25/2024)
)

Help greatly appreciated!

2

Hi Vic,

Try:

DAYS({Deadline}, "2024-09-25")

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

4

Hi Vic,

Revert the 2 dates.

DAYS("2024-09-25",{Deadline})

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

1 Like
5

Thanks Gilles! That seems to have worked for the most part, but is returning a negative value (e.g. “-90” vs “90”). It’s not a huge issue, but do you know why it would do that instead of just showing it as a positive value?

6

That did the trick! Thank you!