Home Inventory in Excel: Appliance List with Warranty Expiry Dates and Alerts (EDATE)

By Ravindra Bagale · Last updated: 17 October 2026

Download the template: home-inventory-warranty-tracker-template.xlsx: example data with real formulas. Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and everything recalculates.

Made-up data: every name, amount, shop and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The example

Salman's home list as of 17-10-2026 (made-up items, prices and dates), 9 items worth ₹2,41,289:

Six items are still under warranty, worth ₹1,65,689. Three expire within 60 days, so any problem with them should be reported now. Two bills are missing (the AC and the mixer grinder), and those rows turn red.

2. Build it step by step

Step 1. As-of date and list

1. In B3 type =TODAY() (the template has 17-10-2026 typed so the example matches).
2. In A5:I5 type Item, Room, Purchase date, Price, Warranty (months), Warranty ends, Days left, Status, Bill kept?.
3. Select B6:B300 > Data > Data Validation > List: Kitchen,Hall,Bedroom,Bathroom,Study; E6:E300: 6,12,24,36,60; I6:I300: Yes,No (drop-down lists).

Step 2. Warranty end with EDATE

1. In F6 type =EDATE(C6,E6): 12-03-2023 for the fridge bought on 12-03-2022 with 12 months.
2. EDATE adds whole months to a date and keeps the same day (EDATE). Format F as a date.

Step 3. Days left and status

1. In G6 type =F6-$B$3. A minus number means the warranty is over.
2. In H6 type =IF(G6<0,"Expired",IF(G6<=60,"Expiring soon","Active")) (nested IF).
3. Copy F6:H6 down.

Step 4. Totals and summary

1. In D15 type =SUM(D6:D14): ₹2,41,289.
2. In L6 type =COUNTIF(H6:H14,"Active")+COUNTIF(H6:H14,"Expiring soon"): 6 under warranty.
3. In L7 type =COUNTIF(H6:H14,"Expiring soon"): 3.
4. In L8 type =SUMIFS(D6:D14,G6:G14,">=0"): ₹1,65,689 (SUMIFS).
5. In L9 type =COUNTIF(I6:I14,"No"): 2 bills missing. In L10 =SUMIFS(D6:D14,B6:B14,"Kitchen"): ₹52,200.

Step 5. Colours

1. Select A6:I300 > Conditional Formatting > New Rule > Use a formula: =$H6="Expired", grey fill and grey text, Stop If True.
2. Add =$H6="Expiring soon" with amber (formula rules).
3. Select I6:I300 > Highlight Cells Rules > Equal To No, light red.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in the file.

4. Common mistakes

1. Adding days instead of months. =C6+365 drifts by a day in leap years. =EDATE(C6,12) lands on the same date every time.
2. Warranty typed as years. E is in months. Two years is 24, not 2.
3. F column shows a number like 46328. EDATE returns a date serial number. Format the cells as Date.
4. Rule order. Put the Expired rule first and tick Stop If True, so an expired item is never painted amber.
5. Only listing big items. Small items like the mixer and the water purifier also have warranties and bills. List everything with a bill.

5. More real examples

Example 1: Extended warranty. Bought an extra 2 years? Add an Extended (months) column and use =EDATE(C6,E6+J6).

Example 2: Service dates. For the water purifier or AC, add Last service and =EDATE(last service,6) for the next service date.

Example 3: Insurance list. The Price column and the Room totals are a ready list of what you own, useful if you ever need home insurance.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I calculate a warranty expiry date in Excel?

=EDATE(purchase date, warranty months). 12-03-2022 with 12 months gives 12-03-2023.

How do I show days left until the warranty ends?

Warranty end − TODAY(). A minus number means it has ended.

How do I highlight items whose warranty is ending soon?

Make a Status column with IF, then a formula rule =$H6="Expiring soon" with an amber fill.

Why use EDATE and not +365?

EDATE adds calendar months, so the end date matches the warranty card even across leap years and short months.

Can I keep photos of bills in Excel?

You can add a link to each bill photo with Insert > Link in a new column, pointing to the file on your phone or computer.

7. Quick quiz

Ten questions on this page. Sign in to save your score.