Results 1 to 3 of 3

Thread: Date Format From Start Day To End Day

  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14

    Date Format From Start Day To End Day

    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

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this

    =TEXT(A3+6,""""&DAY(A3)&IF(MONTH(A3)<>MONTH(A3+6), TEXT(A3," MMMM"),"")&""" - dd mmmmyyyy")
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Hi

    With the formula works correctly.

    Many Thanks, Excel Fox!

Similar Threads

  1. Nth Such-And-Such Day Of The Month
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 01-02-2020, 06:48 PM
  2. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  3. Replies: 17
    Last Post: 12-18-2012, 04:15 PM
  4. Start & End Number Further Converted
    By ayazgreat in forum Excel Help
    Replies: 32
    Last Post: 05-06-2012, 11:39 PM
  5. Week Number And Week Start Day of Week
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 10-24-2011, 07:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •