1. How can I get Month in text form. The formula =month(cellref) is returning only the number of the month. Can I do this without reference to any cell?
2. I want the name of the previous month (as per the system calendar) in a cell e.g if the current month is March, I want February in a particular month. When the month moves to April, the cell should show March. How can I do this?
2. I want the name of the previous month (as per the system calendar) in a cell e.g if the current month is March, I want February in a particular month. When the month moves to April, the cell should show March. How can I do this?