Ravi Sir's Cards › Excel
Home Inventory in Excel (card 1 of 2)
Revision card 1 for Home Inventory in Excel: Warranty end date: =EDATE(C6,E6) gives 12-03-2023; Days left (minus = expired): =F6-$B$3 gives −1,315; Expired / Expiring soon / Active: =IF(G6<0,"Expired",IF(G6<=60,"Expiring soon","Active")) gives Expired. Includes an example data table.
Read card text
What this card says
1 for Home Inventory in Excel: Warranty end date: =EDATE(C6,E6) gives 12-03-2023
Days left (minus = expired): =F6-$B$3 gives −1,315
Expired / Expiring soon / Active: =IF(G6<0,"Expired",IF(G6<=60,"Expiring soon","Active")) gives Expired. Includes an
Example
data table
Learn this in the lesson: Home Inventory in Excel: Appliance List with Warranty Expiry Dates and Alerts (EDATE)