Hi,
I created the following formula in Excel 2003 to indicate the period from day to day.

Example:
20 - 26 novembre 2012
29 dicembre - 4 gennaio 2013

I entered the formula in A2:
Code:
=SE(MESE(A3)=MESE(A3+6);GIORNO(A3)&" - "&GIORNO(A3+6)&" "&TESTO(A3+6;"mmmm")&" "&ANNO(A3+6);GIORNO(A3)&" "&TESTO(A3;"mmmm")&" - "&GIORNO(A3+6)&" "&TESTO(A3+6;"mmmm")&" "&ANNO(A3+6))
Traslate English version would be:
Code:
=IF(MONTH(A3)=MONTH(A3+6);DAY(A3)&" - "&DAY(A3+6)&" "&TEXT(A3+6;"mmmm")&" "&YEAR(A3+6);DAY(A3)&" "&TEXT(A3;"mmmm")&" - "&DAY(A3+6)&" "&TEXT(A3+6;"mmmm")&" "&YEAR(A3+6))
Wonder if you can upgrade now use Excel 2013
Formula.zip

Thanks in advance