#Excel TIP : how to get the number of REMAINING DAYS till the deadline 📅 (formula in description)

💥 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗙𝗼𝗿𝗺𝗮𝘁 𝗖𝗲𝗹𝗹𝘀?
You can custom the format of a cell, using one of the existing codes proposed by Excel (number, currency, date, accounting, etc.), or you can as well type your code, based on the existing codes as a starting point.

👉 In this video, we added a line for each task, and then we inputted the deadline. Excel displays the number of days remaining, and color adapts itself depending on the date.

Here's the big formula you can type in the custom format cell: [Green]#" Day(s) Left";[Red]#" Day(s) Overdue";[Magenta]#" Today"

---

💥 𝗪𝗵𝘆 𝘀𝗵𝗼𝘂𝗹𝗱 𝗜 𝗯𝗲 𝘂𝘀𝗶𝗻𝗴 𝗙𝗼𝗿𝗺𝗮𝘁𝘀 𝗖𝗲𝗹𝗹𝘀?
If the existing codes do not match your needs, you can type your own, based on existing data.

*This feature is also available on Google Sheets under Format/Number/Custom number format.

***

🆕 More videos coming soon!

🎥 This video was shot with a MacBook Air.

***

#formatcells #excel #exceltrend