Forum Discussion
Solved
I need month
how to change Start date and End date because i need only month .for eg. January - vacation - 5 February- vacation - 6 March - vacation - 7 I need like that how to change
- I'm sorry, but what you are asking is unclear. Are you wanting to show the names of the months only, going down in sequential rows? Only three at a time?
If you could post a sample of the spreadsheet you're working with, it might help. But basically a more complete description of what you're doing, how this fits in the larger picture.
For example
You have 01/22/2020 in cell A1. To extract the month, in cell B1, execute the formula: Text(A1, "mmmm").
When you hit the Enter key, you have January in cell B1.
I hope that's what you're trying to do
You have 01/22/2020 in cell A1. To extract the month, in cell B1, execute the formula: Text(A1, "mmmm").
When you hit the Enter key, you have January in cell B1.
I hope that's what you're trying to do