Would you like a date?
If you use dynamic dates and would like for the dates to not show excessive characters then try the below formula, just replace [start date], and [end date] with the fields that contain the start and end date….. =IF(AND(DAY([Start date])=DAY([End date]),MONTH([Start date])=MONTH([End date]),YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D Mmmm YYYY"),IF(AND(MONTH([Start date])=MONTH([End date]),YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D")&" - "&TEXT([End date],"D Mmmm YYYY"),IF(AND(YEAR([Start date])=YEAR([End date])),TEXT([Start date],"D Mmmm")&" - "&TEXT([End date],"D Mmmm YYYY"),TEXT([Start date],"D Mmmm YYYY")&" - "&TEXT([End date],"D Mmmm YYYY")))) Examples and what will happen… 5 March 2010 – 5 March 2010 Will equal…. “5 March 2010” 5 March 2010 – 6 March 2010 Will equal…. “5 – 6 March 2010” 5 March 2010 – 6 April 2010...