# how to achieve particular date

• ### 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)

regards

Friday, July 1, 2016 3:18 PM

• 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