You can’t auto‑generate a full Jain panchang by formula in Google Sheets (tithi, nakshatra etc. need proper panchang calculations), but you can very easily organize a Jain panchang in a Sheet and then fill dates from any reliable Jain calendar.

Here is a simple step‑by‑step method:

1. Create basic structure

In a new Google Sheet, make these column headers in Row 1:

• A1: Date (English)
• B1: Day
• C1: Jain Month
• D1: Tithi (Sud/Vad + number)
• E1: Paksh (Sud / Vad)
• F1: Special Day / Vrat
• G1: Notes (Tap, Anshan, Ekasana, etc.)

2. Auto‑fill Date and Day

1. In A2, type the first date (e.g. `01-01-2026` or `1/1/2026` as per your locale).
2. In A3, put formula to add 1 day:

``` =A2+1 ```

1. Drag this down to the end of the year (365 rows).
2. In B2, get weekday name:

``` =TEXT(A2,"dddd") ```

1. Drag B2 down.

Now you have all dates and weekday names ready.

3. Fill Jain calendar details from a panchang

For each row (each date):

• In C (Jain Month) – write Chaitra, Vaishakh, Jyeshtha, etc.
• In D (Tithi) – write e.g. “Chaitra Sud 1”, “Bhadarva Vad 14” etc.
• In E (Paksh) – “Sud” or “Vad”.
• In F – write important Jain days:

- Paryushan / Das‑Lakshan days - Oli (Ayambil Oli) days - Kalyanak days - Diwali (Mahavir Nirvana), New Year, etc.

• In G – add what tapas or rules you plan (Ekasan, Beasan, Upvas, Paushadh, Pratikraman timings, etc.).

You can copy these details from a printed Jain panchang or a trusted Jain calendar and type them into the sheet.

4. Make it easy to view

• Turn on “Filter” (Data → Create a filter).
• Then you can:

- Filter only “Sud 8–15” for Oli, - Or filter by month, - Or show only rows where “Special Day / Vrat” is not empty.

5. Optional: Separate yearly tabs

• Sheet1: 2026
• Sheet2: 2027
• etc.

Same structure, each year gets its own tab.

---

If you tell me:

• which year,
• and whether you follow Shwetambar or Digambar panchang,

I can give you a ready‑made header plus a few sample rows filled in (you can then extend for the full year).