DateB is a powerful and lightweight date utility add-on for that seamlessly converts dates between the Bikram Sambat (BS) Nepali calendar and the Gregorian (AD) calendar.

With DateBS, you can quickly convert single cells or entire columns of dates using simple custom spreadsheet formulas. Whether you are managing financial records, planning schedules, or organizing event dates in Nepal, DateBS makes calendar conversion effortless.

Key Features:
- Convert Bikram Sambat (BS) dates to Gregorian (AD) dates using =DateToAD().
- Convert Gregorian (AD) dates to Bikram Sambat (BS) dates using =DateToBS().
- Convert AD dates to Nepali Devnagari digits (e.g. २०८०-०५-१४) using =DateToBSNepali().
- Format BS dates into full Nepali text (e.g. १५ भदौ २०८०) using =DateToNepaliText().
- Extract BS month names in English (e.g., "Baishakh") or Nepali (e.g., "वैशाख") using =BSMonthString() and =BSMonthNepali().
- Calculate the Bikram Sambat financial year representation (e.g., "2080/81") using =BSFinancialYear().
- Easily insert today's current date in BS calendar format with one click via the custom sidebar.

Get started in seconds! Simply install the add-on, open Google Sheets™, and start using the custom date functions directly in your spreadsheets.

---
Trademarks:
Google Sheets™ and Google Workspace™ are trademarks of Google LLC.


Whether you are managing finances, schedules, or events, DateBS™ makes converting single cells or entire columns quick and easy.