Bing Date Calculator

You can pick a date range, and get the date filter value for Bing.

Converter Explanation

1. Components

  • Encoded Value: The number (e.g., 19814) Bing uses in its filter to represent a date.
  • Base Date: January 1, 1900 - Bing's starting reference point.
  • Offset: 25567 - Fixed number of days used to align with Gregorian calendar dates.

2. The Formulas

To encode (convert date to Bing number):

Encoded Value = (Days since Jan 1, 1900) - 25567

To decode (convert Bing number to date):

Date = Jan 1, 1900 + (Encoded Value + 25567) days

3. Example

For April 1, 2024:

  • Days since Jan 1, 1900 = 45381
  • Encoded Value = 45381 - 25567 = 19814

Therefore, in Bing's filter:

April 1, 2024 ↔ 19814