Duration in Weeks

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.

Hi @mrosantos,

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 Likes

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

1 Like