excel-addins

This repository contains custom excel addins.

Functions in NepaliMonthName.xlam

• NEPALIMONTH(miti)
  Example: =NEPALIMONTH("2078/01/01") gives Baishakh
  Example: =NEPALIMONTH("2078/11/09") gives Falgun
• NEPALIMONTHNUMBER(miti)
  Example: =NEPALIMONTHNUMBER("2078/01/01") gives 1
  Example: =NEPALIMONTHNUMBER("2078/11/09") gives 11

Installation

1. Download NepaliMonthName.xlam
2. Copy NepaliMonthName.xlam to C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Excel\XLSTART
3. Restart excel program.
4. Now, you can use the functions like, NEPALIMONTH(miti) and NEPALIMONTHNUMBER(miti)

---

To sort the month names in a Pivot Table; the following custom list is needed:

• Baishakh, Jestha, Ashard, Shrawan, Bhadra, Asoj, Kartik, Mangsir, Poush, Magh, Falgun, Chaitra