ndelettre
(Nicolas Delettre)
October 23, 2024, 12:04am
1
Hi everyone,
I am trying to solve a relatively easy thing but can’t seem to find a solution myself.
I have a board with a timeline column. However, i needed to display the day from that timeline so i’ve added a formula column to display it:
However, when the dates are across multiple days (see the last line in the above), i’d like the date column to display “Thursday (start date) to Sunday (end date)”.
Is there a way to do this with formulas?
If not, any ideas would be very welcomed!
Thanks.
1 Like
Bree
(Bree)
October 24, 2024, 2:19am
2
Use the following formula. But use straight quotation marks.
IF(Days({Timeline#End},{Timeline#Start})>0,
CONCATENATE(
FORMAT_DATE({Timeline#Start}, “dddd”),
" to ",
FORMAT_DATE({Timeline#End}, “dddd”)),
FORMAT_DATE({Timeline#Start}, “dddd”))
JCorrell
(Jim - The Monday Man)
October 28, 2024, 9:03pm
4
Hey @Bree
Good job on the formula!
FYI, if you use the “preformatted text” formatting option, you won’t have to worry about the quotation marks. For example:
IF(Days({Timeline#End},{Timeline#Start})>0,
CONCATENATE(
FORMAT_DATE({Timeline#Start}, "dddd"),
" to ",
FORMAT_DATE({Timeline#End}, "dddd")),
FORMAT_DATE({Timeline#Start}, "dddd"))
was inserted like this:
Jim - The Monday Man
1 Like