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 th...
excel
Macros and VBA
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 29, 2021

    CSRouse 

    That could be

    ="For the Month Ended " & TEXT(EOMONTH(TODAY(),0), "mmmm dd, yyyy")
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.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 29, 2021

      CSRouse , you are welcome, glad it helped

Resources