English to Nepali date Converter in Excel

The majority of them do not know how to use the Excel to translate English date into the Nepali date. Since the government documents, school reports, bank statements and personal records in Nepal are of Bikram Sambat (BS) date, there is the need to translate the date of AD to BS. Nevertheless, it may be inconvenient to visit the online converter on a regular basis. In that regard, it is best to create and English to Nepali Date Converter in excel.

After you have created the converter in excel you could then convert thousands of dates to Nepali once by just setting the formula. This would be of much help to accountants, teachers, students, government workers, persons in data entries and web developers. Excel converter is as well time saving particularly where massive data is involved and moreover, it also reduces human error.

In this article, we shall learn how to change, in excel, a date that is in English (AD) to a date in Nepali (BS), its benefits and with an easy technique in a rather straight forward way and with practical illustrative examples. You need not fret, assuming you are an amateur in using Excel in it, this is a step-by-step guide.

English to Nepali date translation in excel.

Excel lacks an inbuilt AD to BS converter. then you have to have a special way.

Procedure 1: Based on a BS Calendar Table that is already built.

Step-by-step:

• Open a sheet in Excel
• Prepare a BS calendar data (AD-BS mapping table).
• Use a formula of VLOOKUP or XLOOKUP.

Here:

• A2 = English date
• Sheet2 = AD-BS conversion table

Method 2 Excel Script / VBA (Advanced)

You may create a full automatic converter, using VBA macro, in case you are an advanced user.

Basic VBA Idea:

• Load BS calendar array
• Take AD date input
• Return BS equivalent

It is an excellent process of automation and tool development.

Benefits of English to Nepali Date converter in Excel.

Time Saving
The hassle of undertaking a manual conversion process is eliminated. Hundreds of dates at the touch of a button.

Bulk Data Conversion
Bank records, payroll, school files, internet records etc. useful.

Offline Use
Excel converter can be used without the internet.

Error Reduction
Human error is reduced. One formula is consistent.

Professional Use
increases productivity of accountants, teachers, government employees.

Easy to create Website Tool
A web tool can also be developed using the assistance of Excel logic.

Example

Assume that you have the following data (in excel) as follows:

BS date can be auto-generated in column B using formula in case the column A includes AD date.

Real-life Use Case:

• In the case of publishing result, school transforms AD into BS.
• Date of completion printing invoice.
• Excel used to make logic to create blog tool.