I'm Trying to display dates in a calculated column in the format of "DD - DD Month Year" (05-10 August 2018) or as "DD Month - DD Month Year" (30 August - 03 September 2018) if the Months are different.
I know the formula for both.
first is:
=CONCATENATE(text([Start Time],"dd"),"-", text([End Time], "DD"), " ", text([End Time], "mmmm"), " ", text([End Time], "yyyy"))
Sencond is:
=CONCATENATE(text([Start Time],"dd"), " ", text([Start Time], "mmmm"),"-", text([End Time], "DD"), " ", text([End Time], "mmmm"), " ", text([End Time], "yyyy"))
I tried making an IF statement but i cant get it to work.
=IF(Month[Start Time] = Month[End Time], =CONCATENATE(text([Start Time],"dd"),"-", text([End Time], "DD"), " ", text([End Time], "mmmm"), " ", text([End Time], "yyyy")), =CONCATENATE(text([Start Time],"dd"), " ", text([Start Time], "mmmm"),"-", text([End Time], "DD"), " ", text([End Time], "mmmm"), " ", text([End Time], "yyyy")))
Please advise how show the dates in specified format?