Job Recruitment Website - Property management - Property statistics table
Property statistics table
1. Use conditional formatting on dates.
For example, A 1 stores the date when the property fee should be paid, which can be set in the conditional format of this cell.
"formula" = and (a 1-today () < 5, a1-today () >; -1) cell and set the color.
In this way, the cells to be paid can be colored in the past 5 days.
2. Use VLOOKUP function combined with TODAY () to find the matching data and display it on other tables.
3. You can also add a column after the payment date column to calculate the date difference of the payment date.
For example, A 1 is the date of payment, followed by a column. In B 1, enter = if ((a1-today ()) >; 0, (a 1-today ()), if ((a 1-today ()) = 0, "the last payment date has arrived", ""))
B 1 can indicate how many days are left before the payment date. If it exceeds the date, it will not be displayed. If it is due on the same day, "The last payment date has been reached" will be displayed.
- Previous article:What are the famous carpet brands in China?
- Next article:What is the telephone number of Yichun Ding Sheng Huafu Marketing Center?
- Related articles
- Restrictive power of residential property
- What about Shanghai Jinbang Property Co., Ltd.?
- Does the property have the right to detain the car?
- How about Hepuwen and Shangcheng Real Estate?
- What are the real estate projects developed by Sun Hung Kai?
- Is there an age limit for property safety?
- Will the houses in Beijing New Village in Huai 'an be demolished?
- My brother came to Kunshan to look for a job. I hope everyone can give me advice!
- Who is the developer of Anshun Honghu boat?
- Is the part-time job in Yu Xiang International Center official?