Excel has always been a software that many partners use at work, but most novice friends say they still don’t know how to calculate the number of days due. For this reason, today I will share the detailed steps for calculating the number of days due in Excel. Get up and take a look. Hope it helps everyone!

                                                             may take the table below as an example, and note that the cell format in the date column is date.

​ ​ Enter the calculation formula =date column-today() in the status column next to it. That is, the expiration time minus the time of day.

After pressing Enter, you can calculate, drag and drop to all cells below. and change the cell format to General.

​​Select this column and click [Start]-[Conditional Formatting]-[New Rule]. In the window, [Format Style] is set to data bar, the shortest data bar in the type is set to the lowest value, and the longest data bar is set to the highest value. Set your favorite data bar color.

After clicking OK, an intuitive table of expiry days will be ready.

Friends who don’t know how to use Excel to calculate the number of days due, don’t miss this article brought by the editor.