Format date formula

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