It has been sometime that people had been requesting for an excel utility that would perform the date conversion from AD to BS and vice versa in Excel itself. Finally, I have had the time to program it and hope that it can help you in some way.
You can download the file here. Sajan.Nepali.Functions.V5.xlam

Available Functions

Function Example Description
AD2BS( “enter_ad_date” )
AD2BS( "12/25/2016")
AD date format ( MM/DD/YYYY )
BS2AD( “enter_bs_date” )
BS2AD( "2073/12/25")
BS date format ( YYYY/MM/DD )
number2words( enter_number ) number2words( 123 ) Returns the result in preeti font
number2words_preeti( enter_number, show_units ) number2words_preeti( 123 ) Returns the result in preeti font. Here show_units is optional and set to false by default; Shows paisa count if set to true.
number2words_unicode( enter_number, show_units ) number2words_unicode( 123 ) Returns the result in unicode. Here show_units is optional and set to false by default; Shows paisa count if set to true.
number2words_english( enter_number, show_units ) number2words_english( 123 ) Returns the result in nepali system ( crore, lakh, thousand ). Here show_units is optional and set to false by default; Shows paisa count if set to true.
BsDatesDiff( “start_date”, “end_date” )
BsDatesDiff( "2073/2/3", "2073/2/5" )
Date count between 2 BS Dates
BsAddDays( “bs_date”, no_of_days )
BsAddDays( "2073/2/3", 5 )
Add or Subtract number of days from a BS Date
  • AD2BS(“enter_ad_date”) // AD date format (MM/DD/YYYY)
  • BS2AD(“enter_bs_date”) // BS date format (YYYY/MM/DD)
  • number2words(enter_number) // Assign the font as Preeti
  • number2words_preeti(enter_number, show_units) // the output is in Preeti font, and show_units specifies if you want to get units (
  • number2words_unicode(enter_number, show_units) // Assign the font as Preeti
  • number2words_english(enter_number, show_units)
  • BsDatesDiff(“start_date”, “end_date”) // Date count between 2 Bs Dates
  • BsAddDays(“bs_date”, no_of_days”) // Add or Subtract number of days from a BS Date

Instructions:

  • Open Excel 2007/2010/2013
  • Click Office Start Button at the top left corner of the screen
  • Select Excel Options
  • In the Excel Options window, select Add-Ins tab from the left sidebar
    Untitled-1
  •  Inside the right side pane, make sure the Manage drop down says Excel Add-ins before you click the Go button.
  • AddIns window is opened up. Click on Browse and navigate to the above downloaded file (Sajan.Nepali.Functions.xlam)
    Capture
  • Check on Sajan.Nepali.Functions in the list and then Click OK
  • You are done.

Limitations

  • Date Range from 2000 BS to 2089 BS.
  • Date Range from 1944 AD to 2033 AD.

Comments