locked
how to achieve particular date RRS feed

  • Question

  • Hi,

    I want the date to show in this way

    1. If  =Text(Today(),"dd/mm/yy") is between 1-15, I want it to show 1 and 15 only. Say if today is 02/07/16, I want it be seen as 01/07/16 and 15/07/16.

    2. If  =Text(Today(),"dd/mm/yy") is between 16-30 or 31, I want it to show 1 and 15 only. Say if today is 19/07/16, I want it be seen as 16/07/16 and 31/07/16 (30/07/16 when month has only 30 days, 28 or 29 in february as well)

    Is it possible ? please help.

    regards

    Friday, July 1, 2016 3:18 PM

Answers

  • Does this formula do what you want?

    =IF(DAY(TODAY())<16,TEXT(TODAY()-DAY(TODAY())+1,"dd/mm/yy")&" and "&TEXT(TODAY()+15-DAY(TODAY()),"dd/mm/yy"),TEXT(TODAY()-DAY(TODAY())+16,"dd/mm/yy")&" and "&TEXT(EOMONTH(TODAY(),0),"dd/mm/yy"))


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, July 1, 2016 3:46 PM

All replies

  • Does this formula do what you want?

    =IF(DAY(TODAY())<16,TEXT(TODAY()-DAY(TODAY())+1,"dd/mm/yy")&" and "&TEXT(TODAY()+15-DAY(TODAY()),"dd/mm/yy"),TEXT(TODAY()-DAY(TODAY())+16,"dd/mm/yy")&" and "&TEXT(EOMONTH(TODAY(),0),"dd/mm/yy"))


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, July 1, 2016 3:46 PM
  • Thanks Hans Vogelaar, Your genius as always.
    regards.


    Friday, July 1, 2016 3:54 PM