00:00I recently posted a video on calculating remaining days. Following that, someone
00:04asked if I could also demonstrate subdividing that by indicating month and
00:08days. For that, you will need to use the following formula. Let's break this formula down a bit.
00:12If the condition of the if statement is met, the first part involves calculating
00:15the difference between the current date and the date in cell B2. The result
00:20is then displayed in the format of years, months, and days using appropriate
00:23notation. The entire calculation is enclosed within the if statement because the date if
00:28function, which computes the difference cannot handle negative number, that is that the
00:31older date is subtracted from the newer date. After that, we apply the same formula
00:35to the rest of the row. And finally, to differentiate due dates, we can implement
00:39conditional formatting. We identify today's due date with the green text.
00:43Non-overdue dates appears in blue, and overdue dates are highlighted in red.
Comments