Duration in Weeks

1

Hi guys, I’ve got a quick question. I’m inserting a formula into a column to calculate the time from a start day to present day. The output is given in days–which is awesome. But is there a way we can turn days into weeks + days instead? It’d be extremely useful for our work if there’s a way around that. Cheers.

2

Hi @anon10723509,

Welcome to the Coda Community!

There isn’t a setting for it in the duration column format, but you can use the Concatenate() formula to calculate and display it.

Concatenate(
  Floor((thisRow.[End Date]-thisRow.[Start Date])/7),
  " weeks ",
  Remainder(thisRow.[End Date]-thisRow.[Start Date],7),
  " days"
)

Floor() is just rounding down after dividing by 7.
Remainder() is just taking the remainder of the same formula for the days left.

3

Had to play around with my Column names and replace them, but it worked like a charm. Thanks dude!