Nepali Date Functions | AD to BS | BS to AD | Convert Date Format | BS Add Days | BS Dates Diff

In this video, we will learn how we can use the various "Nepali Date Functions" in Excel.

Table of Contents:
00:31 Available Date Formats
00:36 List of available Date Functions
00:41 AD2BS - Basic Syntax
01:22 AD2BS - Advanced Syntax
03:15 BS2AD - Basic Syntax
03:43 BS2AD - Advanced Syntax
05:37 ConvertDateFormat
07:18 BsAddDays
08:24 BsDatesDiff

Prerequisite:
Download and install the latest version of the "Nepali Functions Addin for Excel" from the following link:
► http://sajanmaharjan.com.np/my-works/...

Website:
► http://www.sajanmaharjan.com.np

FOLLOW ME

Facebook Page:
►   / sajanmaharjan.com.np  

Twitter:
►   / sajanmaharjan  

LinkedIn:
►   / sajanmaharjan  

AVAILABLE DATE FUNCTIONS

► 00:41 AD2BS( “enter_ad_date” )
Example: AD2BS( “12/25/2016”) // Returns 2073/09/10
Returns the converted BS date
► 03:15 BS2AD( “enter_bs_date” )
Example: BS2AD( “2073/12/25”) // Returns 4/7/2017
Returns the converted AD date
► 05:37 ConvertDateFormat("date", "source", "target")
Example: ConvertDateFormat("2077/03/07", "YYYY/MM/DD", "YYYY-MM-DD") // Returns 2077-03-07
Returns date in chosen target format
► 07:18 BsAddDays( “bs_date”, no_of_days )
Example: BsAddDays( “2073/2/3”, 5 ) // Returns 2073/2/8
Add or Subtract number of days from a BS Date
► 08:24 BsDatesDiff( “start_date”, “end_date” )
Example: BsDatesDiff( “2073/2/3”, “2073/2/5” ) // Returns 2
Date count between 2 BS Dates