00:00I recently published a video on how you can calculate days remaining that looks
00:03something like this but someone had a question if I can do the same thing in
00:07Google Sheet. Well this is how I do it. You start off by calculating the number
00:11of days left from today along with column B. So what I mean by that is that
00:15you use a function called today minus the date line on column B like this and
00:21hit enter. After that you can apply the same formula to the rest of the row by
00:25either clicking on this field handler or on that pop-up window there on Google
00:29Sheet. Now you want to customize it so that it displays a text saying days
00:33remaining, days overdue and days today. The way to get around that will be highlight
00:37all your column C data here like this and you go format number custom number
00:44format. In here you'll be entering the following custom number format. If you
00:49like a copy of this custom number format just leave a request on the comment
00:53section of this video and I'll send it to you and then after that hit apply and it
00:57should look something like that. Now to color code this make sure you're still
01:01selecting all the rows on column C like this then you go format conditional
01:08formatting and this pop-up on this side here we're gonna color code blue for non
01:14overdue red for overdue and today's date itself we're gonna color them as green.
01:20Let's start off with overdue change this rule to less than the value will be zero and
01:26basically change the font color to be red because this overdue and make sure you
01:30change the cell color or the fill color to none and it looks something like that
01:34so any overdue should be shown in red text. Now let's do the non overdue ones
01:40you're gonna go and add another rule right here and then this time around we're
01:44gonna say greater than zero and we're gonna color that to say blue like this and
01:50then you can see any days as non overdue will be shown in blue. Now to color this
01:56today's date in green basically click on add now rule over here change the rule to
02:02equal to or is equal to zero and basically change that color to green like this and
02:08you should see all the today's will be green and after that done and after that
02:13let's close this site pop-up window here and then that particular task is complete.
Comments