Date Format From Start Day To End Day

1 Attachment(s)

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
Attachment 633

Thanks in advance

Try this

=TEXT(A3+6,""""&DAY(A3)&IF(MONTH(A3)<>MONTH(A3+6), TEXT(A3," MMMM"),"")&""" - dd mmmmyyyy")

Hi

With the formula works correctly.

Many Thanks, Excel Fox!