Forum Discussion

CSRouse's avatar
CSRouse
Copper Contributor
Jul 29, 2021
Solved

Formatting date in a combined text and formula

Hello,

 

=”For the Month Ended “&DATE(YEAR(TODAY()),MONTH(TODAY()),0)

 

The above formula returns the text and date in the following format: For the Month Ended 44377. I need it to appear like this: For the Month Ended June 30, 2021. How might I alter the formula so that it gives me the desired output.

 

Thanks a lot!

 

excel
Macros and VBA

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 29, 2021

    CSRouse 

    That could be

    ="For the Month Ended " & TEXT(EOMONTH(TODAY(),0), "mmmm dd, yyyy")
    • CSRouse's avatar
      CSRouse
      Copper Contributor
      Jul 29, 2021
      Worked beautifully! Thank you very much Sergei. I most appreciate your assistance.

Resources