=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
- Will equal… “5 March – 6 April 2010”
- 5 March 2010 – 6 April 2011
- Will equal… “5 March 2010 – 6 April 2011” (What were you expecting the Easter bunny!! :-) )
No comments:
Post a Comment