Nepali Calendar Converter

Get the Excel Add-In

Download the professional .xlam file to enable conversion functions across all your local workbooks seamlessly.

📥 Download Add-In File (.xlam)

End-User Installation Guide

Follow these steps to permanently register the functions in Microsoft Excel:

1. Click the Download Add-In File button above and save the file somewhere safe on your device (e.g., your Documents folder).
2. Launch Microsoft Excel and open a blank workbook.
3. Navigate to the Developer Tab on your ribbon line.
   Don't see it? Go to File → Options → Customize Ribbon → Check the "Developer" checkbox.
4. Click on Excel Add-ins (the blocks icon).
5. In the popup window, click the Browse... button, track down your downloaded NepaliCalendarConverter.xlam file, and click open.
6. Ensure that NepaliCalendarConverter is ticked in the active list, then click OK.

💡 The functions are now natively available! You can type them in any cell of any workbook like a built-in Excel feature.

Available Custom Formulas

The add-in introduces three smart formulas that seamlessly parse arbitrary human-written layouts.

1. BSTOAD(BS_Date_String)

Converts a Bikram Sambat date into a native Gregorian Excel Date. This returns a true Excel Date Serial Number, which you can format using normal Excel cell tools.

2. ADTOBS(AD_Date, [OutputFormat])

Converts an standard Western date into a formatted Bikram Sambat (BS) text string. Since Excel doesn't handle BS dates natively, these are returned as clean text.

3. DATECONVERT(Date_String, Direction, [OutputFormat])

A unified formula configuration tool for pipelines.

Accepted Input Layouts

The intelligent parser safely breaks down non-uniform user entries. All of the structural combinations listed below are fully parsed:

Output Token Customization Matrix

When running ADTOBS, you can define how your final string looks by passing formatting tokens into the second parameter:

Token Token	Meaning / Extraction Output	Sample Example
YYYY	4-Digit Bikram Sambat Year Representation	2082
MMMM	Full Text Name of Nepali Month	Shrawan
MMM	3-Letter Text Abbreviation of Nepali Month	Shr
MM	2-Digit Padded Numeric Month Index	04
DD	2-Digit Padded Numeric Day Value	26