Forum Discussion
Month Format with TODAY date
Hello, I have an issue. How to automatically calculate the name of the month that was 6 months ago and will be in 6 months. I want to show the calculated month names on the axis in place of red lette...
Anonymous Try this:
Previous 6 Month = FORMAT(EOMONTH(TODAY(),-6),"mmmm") Post 6 Month = FORMAT(EOMONTH(TODAY(),6),"mmmm")
Anonymous Try this:
Previous 6 Month = FORMAT(EOMONTH(TODAY(),-6),"mmmm")
Post 6 Month = FORMAT(EOMONTH(TODAY(),6),"mmmm")Greg_Deckler it is perfect solution! Thank you very much!