This article will show you some free and printable personal monthly budget templates or family monthly budgets for google sheet and Microsoft Excel spreadsheet applications, and will also explain some of the features or important functions of these templates. This will make it easy for you to make modifications when using these templates so that you can customize the monthly budget template to meet your specific requirements.

 

If you are currently looking for a free and printable budget planner, then this article is for you. You can keep your finances in healthy condition with a personal or household monthly expense spreadsheet template.

If your personal income or household income is calculated on a weekly basis, then you can also use these spreadsheet budget templates as weekly budget templates.

What Is A Monthly Budget?

A monthly budget is a budget planning used for an individual or household’s monthly income and monthly expenses to determine the balance of monthly savings or debts. A monthly budget is not much different from a personal or household budget, it just specifies the time frame for the budget.

A monthly budget is a plan that you create for each month based on your personal or household income and expenses. This is a plan for all of your expense amounts, which also includes funds for recreational activities or personal entertainment expenses, so creating a solid budget plan can help you achieve your financial goals.

A budget planning can include a comprehensive list of income or expenses, and you can focus on several categories. You can write a budget plan manually or design a reliable, printable monthly budget spreadsheet by using Google Sheets or Microsoft Excel Spreadsheet.

Why Is A Monthly Budget Important?

A simple budget planning is a great benefit for every person or family, not just for those who are struggling financially at the moment. A budget plan encourages you to use your spending on sensible spending items.

It encourages you to live within your means and to put your money to work in the best way possible. Having a designated budget plan is one way to achieve your financial goals. It can help you：

• Track your income and expenses, so you know exactly how much you are saving or spending each month
• Help you plan ahead to use available funds for emergency aggressive or savings goals in preparation for future retirement.
• Planning expenses in advance can reduce the risk of overspending and can help you pay off debts you already have.
•  Relieves financial stress and good planning can help you have a healthy financial situation

What Is A Monthly Budget Template?

A monthly budget template is a tool to help you quickly create a personal or household monthly budget. The budget template will contain two separate columns for monthly income or expenses, and each column will contain specific income items or expense items.

The monthly budget spreadsheet template can also be used as one of your personal financial spreadsheets.

Monthly Budget Templates

Below we will share with you some best free printable, customizable monthly budget templates to help you take control over your finances. These templates can be opened and used in a Microsoft Excel spreadsheet or Google Sheets. You can download them for free and print them out to use.

1. Personal Monthly Budget

 This template is an official personal monthly budget template provided by Microsoft Excel, if you need to use this template in google sheets, then you just need to import the budget template file into google sheets.

You can use this personal monthly budget worksheet to track your monthly total projected income or total actual income and total projected expenses and total actual costs.

You just need to enter various categories of expenses in the form and the projected balance, actual balance and difference will be calculated automatically.

Let’s take a look at how to use this personal monthly budget template.

STEP 1: Firstly, you need to enter your total projected monthly income, which includes the main income item Income 1 and the Extra income item. After that, the total projected monthly income will be calculated automatically by using the SUM formula. The SUM formula used is as follows.

=SUM(E4:E5)

As you can see from the above figure, the SUM formula will automatically calculate the sum of Income1 and Extra income.

STEP 2: You need to enter your actual monthly income in cell E8, which contains the actual income of the month for the main income items Income 1 and Extra income.

When you have entered Income 1 and Extra income, the actual monthly income for that month will also be calculated automatically by the SUM function. The formula used is as follows.

=SUM(E8:E9)

STEP 3: You need to enter the projected costs and actual costs incurred on various categories in the corresponding cells. The template contains 12 major expense categories: HOUSING, TRANSPORTATION, INSURANCE, FOOD, PETS, PERSONAL CARE, ENTERTAINMENT, LOANS, TAXES, SAVINGS OR INVESTMENTS, GIFTS AND DONATIONS and LEGAL.

When you enter the projected cost and the actual cost, the difference between the two costs will also be automatically calculated by the function. The formula is as follows.

='PERSONAL MONTHLY BUDGET'!$C14-'PERSONAL MONTHLY BUDGET'!$D14

STEP 4: Once the projected and actual costs for all categories are entered into the monthly budget worksheet, this template will automatically do a lot of statistical tasks, such as PROJECTED BALANCE, ACTUAL BALANCE, DIFFERENCE, TOTAL PROJECTED COST, TOTAL ACTUAL COST , TOTAL DIFFERENCE.

TOTAL PROJECTED COST：

The TOTAL PROJECTED COST counts the total projected cost of all expenditure items and is calculated using the following SUBTOTAL formula.

=SUBTOTAL(109,'PERSONAL MONTHLY BUDGET'!$C$13:$C$22,'PERSONAL MONTHLY BUDGET'!$C$26:$C$32,'PERSONAL MONTHLY BUDGET'!$C$36:$C$39,'PERSONAL MONTHLY BUDGET'!$C$43:$C$45,'PERSONAL MONTHLY BUDGET'!$C$49:$C$53,'PERSONAL MONTHLY BUDGET'!$C$57:$C$63,'PERSONAL MONTHLY BUDGET'!$H$13:$H$21,'PERSONAL MONTHLY BUDGET'!$H$25:$H$30,'PERSONAL MONTHLY BUDGET'!$H$34:$H$37,'PERSONAL MONTHLY BUDGET'!$H$41:$H$43,'PERSONAL MONTHLY BUDGET'!$H$47:$H$49,'PERSONAL MONTHLY BUDGET'!$H$53:$H$56)

TOTAL ACTUAL COST：

The TOTAL ACTUAL COST is used to calculate the total actual cost of all expense items, which is summarized by the following SUBTOTAL formula.

=SUBTOTAL(109,'PERSONAL MONTHLY BUDGET'!$D$13:$D$22,'PERSONAL MONTHLY BUDGET'!$D$26:$D$32,'PERSONAL MONTHLY BUDGET'!$D$36:$D$39,'PERSONAL MONTHLY BUDGET'!$D$43:$D$45,'PERSONAL MONTHLY BUDGET'!$D$49:$D$53,'PERSONAL MONTHLY BUDGET'!$D$57:$D$63,'PERSONAL MONTHLY BUDGET'!$I$13:$I$21,'PERSONAL MONTHLY BUDGET'!$I$25:$I$30,'PERSONAL MONTHLY BUDGET'!$I$34:$I$37,'PERSONAL MONTHLY BUDGET'!$I$41:$I$43,'PERSONAL MONTHLY BUDGET'!$I$47:$I$49,'PERSONAL MONTHLY BUDGET'!$I$53:$I$56)

PROJECTED BALANCE:

PROJECTED BALANCE is used to calculate the total projected income minus the total projected cost. The total projected cost is calculated using the formula above.

ACTUAL BALANCE：

ACTUAL BALANCE is used to calculate the total actual income minus the actual cost. Where the total actual cost is calculated using the formula above.

If you have other requirements for a customized budget template, you can send us a message.

If you are looking for personal monthly budget template, check out Microsoft office site by clicking here.

2. Simple Monthly Budget Template

 This template is designed by MintLife and it needs to be opened by default via Microsoft Excel Spreadsheet.

Note: You cannot use this monthly budget template in google sheets because many of the statistical formulas in the template are only available in Microsoft Excel and google sheets does not recognize these formulas. If you are willing to use this template in google sheets, you can leave us a comment and we will help you how to adapt these formulas in google sheets.

The monthly budget template contains three parts: Income Input, Expense Input, Budget Summary. These three parts are placed in three separate worksheets.

Let’s see how to use this monthly budget worksheet:

STEP1: First you need to go to the Income Inputs worksheet and enter the estimated income and actual income in the corresponding income items under the ESTIMATED and ACTUAL columns. You will then see that the value of the income difference will be automatically calculated using Microsoft Excel or Google Sheets formulas.

As you can see from the above figure, the total projected income and the total actual income are also counted automatically.

The formula to count the projected total income is as follows.

=SUBTOTAL(109,[ESTIMATED])

The formula to count the actual total income is as follows.

=SUBTOTAL(109,[ACTUAL])

Both projected and actual total incomes need to be summed up by the SUBTOTAL function for the corresponding ESTIMATED and ACTUAL columns.

STEP2: In the Expense Inputs worksheet, you need to enter the estimated and actual costs for the corresponding expense items in the ESTIMATED and ACTUAL columns. The values in the DIFFERENCE column will be automatically calculated.

Once all the expense items are entered, the total projected expense and total actual cost values are also automatically calculated. This template calculates the total expenses by using the SUBTOTAL function and automatically calculates the difference between the estimated total expenses and the actual total cost.

The formula is as follows.

=SUBTOTAL(109,[ESTIMATED])
=SUBTOTAL(109,[ACTUAL])
=SUBTOTAL(109,[DIFFERENCE])

From the above figure, we can also see that the Expense inputs worksheet has also added a Clustered Column chart, so you can see more clearly the ratio of estimated and actual expenses for each item.

STEP3: After entering the Income Inputs and Expense Inputs worksheets, you can go to the Budget Summary worksheet.

This worksheet contains 2 statistics, one for total income and total expenses, and one for the top 5 actual expenses.

As you can see from the above screenshot, Total Projected Income, Total Actual Income, Total Projected Expenses, and Total Actual Cost are automatically extracted from the Income Inputs and Expense Inputs worksheets using the following formulas.

=Income[[#Totals],[ESTIMATED]]

=Income[[#Totals],[ACTUAL]]

=Expenses[[#Totals],[ESTIMATED]]

=Expenses[[#Totals],[ACTUAL]]

Where Income and Expenses are the two defined Name Ranges.

Income = "Income Inputs"! $B$6:$F$13

Expenses = "Expense Inputs"! $B$6:$F$18

This template will count the top five actual expense items and automatically calculate the percentage of each expense item to the total expense amount. The top five spend items are found from the Expense Inputs table using the following LARGET function.

=LARGE(Expenses[TOP 5 AMOUNT],1)

If you are looking for simple monthly budget template, check out mint site by clicking here.

3. Detailed Monthly Budget Template For Excel Sheet

 This template is also designed by MintLife and needs to be opened and used by Microsoft Excel Spreadsheet by default.

The difference between this template and the simple monthly budget template above is that the Expense Inputs worksheet categorizes all expense items and contains 12 expense categories: House, Education, Shopping, Health & Fitness, Personal Care, Kids, Food & Dining, Gifts & Donations, Investment, Bills & Utilities, Auto & Transportation, Travel and Fees & Charges. Dining, Gifts & Donations, Investment, Bills & Utilities, Auto & Transportation, Travel and Fees & Charges.

Note: You cannot use this monthly budget template in google sheets because many of the statistical formulas in the template are only available in Microsoft Excel and google sheets does not recognize these formulas. If you are interested in using this template in google sheets, you can send us a message and we will assist you on how to adapt these formulas in google sheets.

This template is used in the same way as the previous one, when you have finished entering the income and expense items, the Budget Summary page will also have separate statistics based on expense categories. The following VLOOKUP formula is used to get the estimated and actual total expenses for each expense category.

=IFERROR(VLOOKUP([@[EXPENSE CATEGORIES]],'Expense Inputs'!B:F,3,FALSE),"-")

=IFERROR(VLOOKUP([@[EXPENSE CATEGORIES]],'Expense Inputs'!B:F,4,FALSE),"-")

The total expense table also automatically calculates the difference for each expense category and automatically determines whether the current category exceeds the budgeted amount based on the difference.

If you are looking for a detailed monthly budget template, check out mint site by clicking here.

4. Family Monthly Budget Planner

 This template is a free and printable blank monthly household budget template that you will need to open it via google sheets. If you need to use it in Microsoft Excel Spreadsheets, then you will need to download it as a local xls file via google sheets.

The template freezes the first six rows so that the income, expense and balance information for each month is always displayed. The first six rows contain the total family income, total family expenses and total balance for each month, and the total family income and total family expenses for a year are also calculated automatically.

The formulas used are as follows.

=sum(B4:M4)

Let’s see how to use this monthly household budget template.

STEP1: First you need to enter the values of the various income items in the corresponding month column in the Income table.

STEP2: You need to enter the actual expenses in the expense category sub-table; after that you will find that the relevant statistical items in the template will be calculated automatically.

This template contains only actual income items and expense items, and does not include projected income and projected expense.

If you are looking for a blank family monthly budget template, check out it by clicking here.

5. Personal Monthly Budget Template

 This template is designed by Vertex42 and this template needs to be opened by Google sheets by default.

This free monthly personal budget template includes an income breakdown, an expense breakdown, and a monthly budget summary.

The income table contains 3 parts: projected income, actual income and income difference.

The expense table is recorded by different expense categories and also contains 3 parts: Estimated Expenses, Actual Expenses, and Expense Difference. The table contains ten expense categories: HOME EXPENSES, TRANSPORTATION, HEALTH, CHARITY/GIFTS, SUBSCRIPTIONS, SAVINGS, OBLIGATIONS and MISCELLANEOUS.

The usage of this template is basically the same as the first template, you just need to enter the corresponding data in the INCOME and EXPENSES tables, and the various statistics will be calculated automatically.

The MONTHLY BUDGET SUMMARY table will automatically calculate the total projected income, total actual income, total projected expenses and total actual expenses.

If you are looking for a personal monthly budget template, check out it by clicking here.

6. Personal Monthly Budget Template

 This is a very specific personal monthly budget template. This template contains two parts: income breakdown and expense breakdown. This template will count the expenses for each day of the given month.

Let’s see how to use this monthly household budget template.

STEP1: You need to enter the various actual income values in the INCOME line and the total actual income will be calculated automatically.

STEP2: In the expense table, select the current month, for example, select May

STEP3:  After that you need to enter your actual daily expenses in the expenses tab. If your expense items are not shown in the expense table, then you can add them by yourself.

After that, the total expenses and the current available balance for the day will be calculated. The formula used for this is as follows.

=SUM(B8:V8)

=X8-sum(B9:V9)

STEP4: The template also calculates the actual expense for a given month on an expense item, and will automatically calculate the difference.

If you are looking for a personal monthly budget template, check out it by clicking here.

7. Template Business Monthly Budget Template

 This template is a business monthly budget template that counts the monthly revenue and various expense items of the company for each month.

The template categorizes the company’s revenue items and contains various sub-categories under each income category, and counts the actual revenue of each sub-category for each month.

The template also categorizes the company’s expense items, and contains various expense items under each expense category.

This template summarizes all revenue items and all expense items for each month.

Let’s see how to use this template:

STEP1: Enter the name of your company and insert the company logo

STEP2: You need to define the income categories and income subheadings according to your company and enter the actual income values for each month. When you entered all the revenue item values for a certain month, you can see that the total revenue for that month will also be counted automatically. The formula used is as follows.

=ROUND(C8+C13;2)

When the value of the income items for certain months is entered, you should see that the total income for the year is also automatically calculated;

The following formula is used：

=ROUND(O8+O13;2)

STEP 4: Enter the actual expenses in each month’s expense item, and the total expenses for each month will also be calculated automatically. When the actual expenses are entered in the expense items of multiple months, the actual expenses of the year will also be calculated.

=round(O20+O30+O36+O40;2)

If you are looking for a free business monthly budget template, check out it by clicking here.

8. Monthly Budget Template

 This monthly budget template is officially provided by google sheets, where the Summary worksheet contains various statistical functions.

Let’s see how to use this template:

STEP 1: First of all, you need to set your starting budget balance in cell L8 of the summary sheet.

STEP2: Customize your categories and planned expense amounts in the Income and Expenses table of the Summary worksheet.

STEP 3: Enter the expense and income data in the transaction worksheet, after that you will see the actual income data and the actual expense data in the income and expense tables will be updated automatically in the summary worksheet as well.

STEP 4: This budget template shows projected total expenses, actual total expenses, projected total income and actual total income in the form of small charts, allowing us to visualize the status of variances.

If you are looking for a free business monthly budget template, check out it by clicking here.

Related Functions

• Excel SUM function
  The Excel SUM function will adds all numbers in a range of cells and returns the sum of these values. You can add individual values, cell references or ranges in excel.The syntax of the SUM function is as below:= SUM(number1,[number2],…)…
• Google Sheets SUBTOTAL function
  The Google Sheets SUBTOTAL function returns the subtotal of the numbers in a list or database. The syntax of the SUBTOTAL function is as below:= SUBTOTAL (function_num, ref1, [ref2])….
• Google Sheets VLOOKUP Function
  The Google Sheets VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position..The syntax of the VLOOKUP function is as below:= VLOOKUP (lookup_value, table_array, column_index_num,[range_lookup])…
• Excel IFERROR function
  The Excel IFERROR function returns an alternate value you specify if a formula results in an error, or returns the result of the formula.The syntax of the IFERROR function is as below:= IFERROR (value, value_if_error)….
• Google Sheets LARGE function
  The Google Sheets LARGE function returns the largest numeric value from the numbers that you provided. Or returns the largest value in the array. The syntax of the LARGE function is as below:= LARGE (array,nth)…
• Excel Round function
  The Excel INT function rounds a number to a specified number of digits. You can use the ROUND function to round to the left or right of the decimal point in Excel.The syntax of the ROUND function is as below:=ROUND (number, num_digits)…

Everyone will be very much looking forward to their wedding, but actually preparing a wedding is very complicated and trivial, there are many small details to pay attention to, we will list in this article a comprehensive list of each detail to be prepared, according to the actual needs of the bride and groom, customize your own wedding plans. Our wedding planning list is organized by month, and couples can also adjust each plan according to their own time before and after.

We will also share with you some free printable wedding planning checklist templates. You can customize your own wedding planning spreadsheet based on these free templates to fit your own requirements.

You can also design it as a printable wedding planner so that you can plan your wedding better.

12 Months

1. Confirm Wedding Date

The bride and groom can choose a wedding date in consultation with each other, and it is best if everyone is available to attend your wedding. It is best to choose 2-3 more dates as a backup so that you will not be overwhelmed if there are changes in your plans.

2. Marriage Application

After getting engaged, depending on the location, you can prepare your personal documents to make an appointment for a marriage application online or at the town hall.

Depending on the religion, you can start making appointments with a trusted and familiar priest and church to have the priest attend your marriage ceremony; if you are atheist, you can choose a judge and get a marriage certificate at the court; or you can choose to go to the city hall to have the mayor issue a marriage certificate for you.

3. Wedding Budget

Discussing a budget is the most important part of the pre-wedding process. This is because the budget determines what your wedding will look like in the end. All services need to be supported by money.

When discussing the budget, the bride and groom need to be sure who contributes mostly to the budget and what parts it consists of, such as whether the couple contribute more, or the groom’s family contributes more, or the bride’s family contributes more.

In the process of discussing the wedding budget, make sure that both sides can discuss peacefully and finalize a reasonable budget.

It’s also a good idea to set aside some backup for additional expenses. We want to keep the final spending within a reasonable amount. The budget is the core of the wedding planning list, determine a good budget, so that the subsequent plans can be reasonable.

You need to create a wedding budget spreadsheet based on your actual situation, so that you can better control the wedding expenses.

4. Making a Wedding Guest List

Each couple may have different needs for wedding planning preparation, but the same thing is to create a wedding guest list. A wedding guest list will provide statistics on the gender of the guests, relationship with the bride and groom, contact information, addresses, dietary preferences, habits, wedding table plan, etc.

By making a wedding guest list, you can make a prior assessment for sending invitations, designing the banquet, wedding seating arrangement, sending gifts, etc. and avoid unnecessary troubles.

There are many free templates for wedding guest list online, and many templates on our website, you can search online for free templates that best meet your requirements, or of course, you can pay for more advanced and functional templates, or even customize the templates.

5. Determining the Wedding Theme or Style

Designing a wedding theme should be one of the most important concerns of the couple, and is also an important part of the wedding to do list. Because a wedding is once in a lifetime for most people, everyone wants to have an unforgettable and unique wedding.

Since everyone has different preferences, it is important for the bride and groom to discuss the wedding theme and try to meet the requirements of both parties.

Some people like fairy tale themes, some like paradise themes, some like garden themes, others like vintage and cosplay, etc. The main thing to determine the wedding overall theme is that both sides like it, but also to consider the budget, whether the Wedding venue is good to find, whether it will make the guests feel relaxed and happy, etc.. Couples can find some photos of the theme online and see if they like it.

6. Finding a Wedding Planner / Assembling a Wedding Team

This team can be a hired professional wedding planner or a personal friend or family member. You can choose a professional wedding planner, professionals can help you save a lot of time, very efficient and no mistakes, they will recommend or arrange the wedding venue, activities and other logistical matters for you according to your budget, help you deal with a lot of loose ends, so you do not worry too much, but of course hiring a team is expensive.

Of course, you can also ask other friends and family for advice. Friends who are already married can provide you with a lot of friendly and practical help, so that you can avoid mistakes in the process of preparing for the perfect wedding planning.

As public acceptance grows, you can also take on some non-traditional wedding challenges to make your wedding unique and memorable. Develop your brain, it’s all about making your wedding perfect!

7. Selecting a wedding venue

After determining the wedding theme and style, it’s time to select the wedding party venue. Some people like to have their wedding at home on the lawn, some want to go to a restaurant for a big meal, some like to have their wedding at an amusement park, some like old castles, some like the beach.

Before selecting a venue consider whether you plan to find a free venue or a paid one, public or private. When searching for a venue, identify your keywords, such as free, beach, available for weddings, etc. In addition to fitting the theme of the wedding, the venue should be able to accommodate a large enough number of guests, be able to host guests, and provide the ability to hold the wedding.

8. Selecting a Caterer

Usually after the venue is determined we have to start thinking about finding a caterer. If the venue has the ability to provide a caterer, you can contact the venue’s caterer directly and can see what they have provided for the wedding before. If not, it will have to be outsourced to another catering company. If you wish, you can also find your favorite chef and prepare it yourselves.

11 Months

1. Designing wedding cakes, dessert tables

– Wedding Cake

Legend has it that in ancient times when rich families held weddings, the bride and groom would make a very large flat round loaf of bread and everyone would share this large loaf of bread, meaning sharing happiness and joy. Slowly the flat round bread developed into the current cake.

More and more brides like to customize their cakes and are very particular about them. Modern wedding cakes are not limited to the traditional style, there are many choices. There are single tier cakes and multi tier cakes, square and round shapes. Multi-tiered gorgeous cakes can be seen by every guest at the wedding, leaving a deep impression on the guests.

Nowadays, wedding cakes are also decorated with great care and can be made unique with flowers and ornaments. But the more luxurious the cake, the higher the cost. The bride and groom can consider the option of finding a supplier to customize the cake, but also completely handmade cake, two people together to make the cake is also full of love.

– Dessert table

In addition to the wedding cake, you should also start designing the dessert table. Cupcakes or cut up cakes or whole cake pies. You can choose the style of dessert that you both really like, and of course consider the ease of holding and eating for your guests. If there are a lot of small children, consider whether you want to make a lot of cute sweets.

2. Hire a Wedding Planner, Photographer, Band, etc.

If you are planning to hire a wedding planner to plan your wedding, this is the time to start talking to potential candidates. Look for someone you can trust and who understands your wedding concept.

In addition to the wedding planner, you also need to consider whether you need to hire a professional photographer, band, etc. You can choose to have a friend who is good at photography as your wedding photographer to help you with photography and take beautiful pictures.

You can also ask him to help you create a wedding photography checklist or you can do it yourself.

3. Determine the Main Color of the Wedding

According to the theme and style of the wedding to determine the main color of the wedding, of course, you can also choose your favorite color or lucky color. The main color of the wedding can help to better choose the wedding dress, allowing guests to choose the right dress to attend the wedding.

10 Months

1. Plan Your Honeymoon Destination

First of all, it is still necessary to consider the Wedding budget, not only the overall amount of money to be spent, but also the proportion of each expense, for example, 50% of the cost of accommodation, 30% of transportation, the percentage of food and beverage, etc., to determine which one you are more willing to spend money on and which one to save money.

Then estimate how long you can set aside for your honeymoon, that is, the length of the honeymoon, if the time is long, the choice will be very much; in considering the destination of the honeymoon first of all to consider their interests, must be the place you want to go, but also to consider is the main leisure and relaxation, or to explore the discovery for fun, is domestic or foreign, is a city or multiple cities, but also consider whether the destination is safe.

Also consider the seasonal factors, such as where to go in winter, where to go in summer, etc.

The bride and groom can provide their own honeymoon destination for both parties to choose from, such as beaches, islands, African savannah, famous cities and so on.

Regardless of the final choice, it is important to be considerate of each other.

2. Buying a Wedding dress / Lingerie / Wedding shoes / Veil / Gloves, etc.

As a bride, everyone wants to be the brightest and most beautiful person at the wedding, a beautiful and suitable wedding dress is essential. You can start ordering your wedding dress about 10 months before the wedding. Make a good strategy online to determine the wedding dress brand, style, you can choose a wedding dress that suits your body shape, and your usual dressing style.

If you consider renting, then you can start looking for a wedding dress renter. The veil can be matched with the wedding dress, or can be purchased separately, and there are even brides who like the simple style without the veil. When buying wedding shoes, consider the comfort of the wedding shoes, whether they are also suitable for other occasions, etc. After the wedding dress is determined, you should buy the right underwear.

3. Selecting a Wedding Cake Supplier

After determining the style of your wedding cake, you can take the model or drawing to find a wedding cake supplier. You can also go directly to the cake supplier to provide your ideas and inspiration to the cake makers to design the cake style, you can communicate the details of the cake such as what material to decorate the outside, whether it is edible, what kind of jam to use inside the filling and so on.

If the cake is not very complicated, you can choose an inexpensive cake store or even make your own. When choosing a cake store, in addition to the taste of the cake, you should also consider the transportation of the cake, whether the cake maker will make it on site or have it delivered in the store, and the delivery should be careful not to damage the shape of the cake. This is to ensure that the cake store should not be too far from the wedding venue.

4. Designing Bouquets, Arrangements and Other Decorative Items

If you are a design genius, this is the time to start thinking about your wedding bouquet, how many bouquets you need, the variety of flowers, how to decorate them, whether you need ornaments and so on. You can browse many wedding websites, wedding pictures, reference to how others are decorated, these samples can provide you with inspiration.

5. Book Suppliers for Bouquet Arrangement etc.

Once you have designed your flower decorations, it’s time to start looking for a flower bouquet supplier. You can leave it to a professional wedding planner to provide flowers and flower decorations, or you can start growing flowers in your yard.

9 Months

1. Book a hotel for the wedding guests

Once the Wedding guests for the wedding have been determined, the bride and groom will need to start thinking about the guests’ accommodations. If you are just hosting a luncheon or dinner party at home or locally, accommodation will be omitted, but if you have guests coming from far away, you will have to start thinking about booking hotels for them.

Check multiple websites for booking hotels based on the guest’s preferences and usual hotel habits to choose the right one, and you may also get a good discount if you book in advance, and see if you can cancel the reservation, if breakfast is included, and other conditions when booking.

If you are staying in a private residence, you can start assigning rooms to take care of the needs of your guests; older people may prefer quiet and younger children may need a larger area to move around.

2. Create a wedding website

In order to let everyone know about your wedding and send you well wishes, the couple can create their own host event on the wedding website.

Design your own save-the-date card, which can be sent directly to your friends and family through the website. Family and friends will pick out gifts for you, so look forward to it.

You can also print the wedding page link to your save-the-date cards in the traditional way, so that your guests will pick out gifts for you when they receive the invitation.

3. Designing Wedding Invitations

Nowadays there are very many free templates for wedding invitations, and the designs are very beautiful and stylish. If the couple wants to save the step of designing the invitations, they can just find the template they like on the website and make a few changes to turn it into their own invitation.

If you wish to design a unique invitation yourself, you can add your story, profession, and the process of meeting and falling in love to the invitation.

Invitations are usually sent out six to eight weeks before the wedding, so it’s important to get a good idea of when you want to design your invitations.

8 Months

1. Practice Taking Wedding Photos

There are many popular photos on ins, you can try more according to their poses, take photos from different angles and find the pose that makes you most photogenic. If the wedding photographer has time, you can make an appointment to practice taking photos, which will make your wedding photos shine.

If you have high requirements for wedding photos, or the photographer is not satisfied after the shooting, it is time to communicate and point out the need to improve, to see if you need more professional equipment, or need to purchase some auxiliary equipment such as fill light.

2. Choosing A Gift

In some countries, gifts are not required, but if you are planning to give your guests a small token of your appreciation, consider preparing some gifts. You can choose something memorable, such as a small perfume with your signature on it, chocolates, or a small mug.

3. Determining the Witnesses/Bridesmaids/Groomsmen

This should not be a problem. Many people, even if they are not in a relationship, have decided who they want to be their witnesses, maid of honor, and best man.

Many bridesmaids and groomsmen are the closest childhood friends, the most trusted friends, and the most compatible partners.

4. Determine the Wedding Speech

It can be someone who witnessed your relationship, a close elder, a trusted official, the groomsman is fine.

5. Determine the wedding host

The host can be your family and friends, if the wedding is more serious and sacred, you can ask a priest you trust, or a respected person; if the party is relaxed and happy, you can find someone who can liven up the atmosphere; the newlyweds can also officiate the wedding themselves.

6. Choosing A Bridesmaid Dress

The bridesmaid is a very important person in the wedding, she witnessed your love, buy a beautiful bridesmaid dress for her. Bridesmaid dresses should be the same style as the wedding dress and not vary too much.

As a thoughtful bride, the bridesmaid dresses should not be too fancy, but suitable for the bridesmaids.

7. Hiring A Band or DJ / Hiring A Musician for the Ceremony

If you have the ideal band, DJ, you can sign a service contract.

8. Booking a Rehearsal Wedding Banquet Venue

The wedding is not just a matter of setting the date, venue and process. Even if everything is ready, the wedding process needs to be rehearsed beforehand to see if there are any improvements that need to be made.

Traditionally, the groom would book a rehearsal banquet venue for the bride and groom and attendants to rehearse.

9. Determine the Rental Items

If you’re having a lawn wedding, you’ll need chairs, a serving table, a cold table, a canopy, and many other items. If you are buying all of these items yourself, consider the price point of the configuration and services.

The more pleasant If you are outsourcing to a wedding planner, see if you are satisfied with the options they offer and if you want to upgrade your services.

7 Months

1. Prepare A Gift List

The bride and groom can sign up for your gift list on the wedding website to make it easier for guests to choose. You can list the gifts you want, such as small appliances, tableware, etc. These gifts contribute to the creation of your new family.

2. Send a Save-the-Date Card

It’s time to send out the cards. Let everyone know the date and location of your official wedding. Everyone can go to the wedding website to pick out your gifts.

3. Buy or Rent the Groom’s Suit

You can purchase a well-fitting suit for the groom, go to a store to get measured and choose the right size and color, which should match the bride’s wedding dress. If you want to save budget, you can consider renting a groom’s tuxedo. If the groom holds to an eco-friendly and simple style, he can also wear a simple shirt.

4. Pre-marital Counseling

After the engagement ceremony, some couples may have certain fears about entering into married life, and may think nonsense and feel stress about the future life of two people. This is the time to avoid ruminating and to seek counseling from a psychologist or to relax with friends. Both sides should be honest face for the problems in the marriage, to find the right solution.

6 Months

1. Booking of Guests’ Transportation / Car Rental

Whether you are going to a church to receive a marriage certificate, or to a restaurant, or to a party venue, you will have to rent a vehicle to take all your Wedding guests to the designated venue. Couples can start renting a car. If your wedding venue is in another country such as an old Scottish castle, start booking tickets.

2. Booking Transportation for The Newlyweds

How do you arrive at the party venue after receiving your marriage certificate? Should we rent a limo? Or a cool motorcycle? Or maybe just walk? If necessary, rent a wedding car of your choice, although the fee is not low, but you can get to the party venue in comfort.

3. Discuss The Menu with The Caterer/Try The Meal

If holding your party at a restaurant, start discussing your meals with the restaurant’s chef. Experienced restaurants will offer many wedding party catering combinations, or you can order your own.

This stage is mainly about trying out all the possible foods that will be available at the wedding reception and combining a menu.

4. Determine The Wedding Cake / Dessert / Sweets

Once you have decided the dessert supplier, the supplier will provide many kinds of desserts, so you can take time to try these desserts and choose your favorite flavor.

Trying the cake will allow the cake maker to make adjustments to suit your tastes. The wedding cake will also have to be finalized.

5. Buying Wedding Rings

Usually, a diamond ring is given by the man for the woman at the time of engagement; after the engagement, both parties have to purchase a wedding ring.

Traditional wedding rings are round rings, and branded wedding rings can be considered if you have an adequate budget. The wedding ring has to meet the preferences of both parties because it is for both parties.

5 Months

1. Designing Wedding Hair and Makeup

In addition to the wedding dress and gown, the right hair and makeup will make the bride and groom shine on their wedding day. Hair and makeup should match your own traits and also match your dress.

During the time before the wedding ceremony, you can refer to celebrities or wedding ads to see if there is a hairstyle and makeup you like. If there is a makeup artist that you like, you can also ask her to help you design your wedding makeup. If the wedding is a very fresh style and you want to be casual, you can also try to coil your hair and braid it yourself, without being so delicate and meticulous.

2. Determining the Final Dish

After tasting the meals provided by the suppliers, it is the time to determine the dishes. It is necessary to determine the dishes in advance, and if there are rare ingredients suppliers can also be purchased in advance.

3. Communicate with The Officiate about The Flow of the Ceremony

The wedding arrangements should be communicated with the officiate in advance, including the introduction of the couple, the flow of the ceremony, the interaction with the guests, etc.

The bride and groom tell the officiate what style of wedding they prefer, whether they prefer a grand or relaxed wedding.

4 Months

1. Trying on Wedding Dresses

Even if you have already tried on the dress you bought or rented, you should try it on again after you get it. Put on the veil, gloves, accessories, etc. that you will need for your wedding day.

It is a good idea to have a bridesmaid accompany you during this process, assuming it is now the day of the wedding, so that you can spot possible problems in advance and fix any problems with your dress or accessories as soon as possible.

The bridesmaids can also keep a record of any problems that may arise during this process to increase their experience in solving problems, which will also allow the bride and bridesmaids to work better together on the wedding day.

2. Rehearsal of the Luncheon/Dinner

If the requirements for the wedding are high, the wedding is grand, there are more guests and the process is complicated, then you need to rehearse the wedding in advance.

This includes the layout of the venue, whether the tables and chairs are properly placed, the flow of each part, where the couple should appear, the position of the band and so on.

Many problems are found at the rehearsal site, so that problems can be avoided on the wedding day. An appointment for the wedding rehearsal should be made in advance with the venue provider or hotel. The rehearsal will take place at the scheduled time.

3. Choosing Wedding Songs List

There are really many elements that create the atmosphere of a wedding, and beautiful music is an essential part of it.

Whether it is the music when the bride arrives in front of the groom with her father on her arm, the music when the wedding rings are exchanged to seal the deal for life, or the music at the reception, couples should choose a good list of wedding music songs before the wedding.

Many people identify the music they want to play at their wedding before the ceremony and give the song list to the musicians so they can know and practice it ahead of time.

4. Design the Flower Arrangement with the Flower Supplier

After selecting the flowers, designing the arrangement style and contacting the flower supplier, you can ask the supplier to visit the site to see exactly how the flowers should be placed, whether they are restricted by the venue or local temperature conditions, etc.

If the ideal flower design can be implemented, there is no need to change the plan, if not, the arrangement still needs to be adjusted.

3 Months

1. Modify Invitation Template／Order Invitation

Wedding invitations will be sent out one to two months before the wedding, so it is important to purchase invitations three months before the wedding.

2. Purchase a Thank You Gift

If expressing gratitude to a special guest, or a guest who has come from afar, you can purchase a few thank you gifts that are not small gifts prepared for each guest, but are specifically targeted for the special guest. It can be a bottle of good wine, a piece of homemade cake.

2 Months

1. Sending Wedding Invitations

One to two months before the wedding, it’s time to send out wedding invitations to friends, classmates and colleagues. Some may need to be delivered in person by the newlyweds, while others will need to be sent by mail.

Start sending invitations according to the address registered on the wedding guest list. Paper invitations are traditional and heartwarming, and if you want to be more eco-friendly, you can opt for electronic invitations.

2. Purchase All Small Items

This is the time to check to see if there are any items that need to be purchased or forgotten. For example, ribbons, small decorative items, etc.

3. Prepare the Gift Bags

Start wrapping the gifts, including the companions and thank you gifts; if there are any decorations to be assembled, start preparing them as well.

4. Check Wedding to Do List or Wedding Scheduled List

Now you can start doing some of the things you need to prepare in advance, check the wedding checking list or wedding scheduled list and tick off all the things you have done.

5. Creating the Wedding Seating Plan

At this point, with guests all identified and the venue confirmed, it’s time to start determining the finer points of each guest’s location. Seating assignments for elders, friends, colleagues, etc., should be discussed with both parents, as both guests should be accommodated.

6. Making Seating Cards

There are many templates available online that you can print out yourself after choosing; you can also purchase seating cards directly; or they can be provided by the venue service provider (such as the hotel service department) or the wedding planning team.

7. Venue Rehearsal

This time it is a full rehearsal and it is best to invite all teams that provide services, including the band, photography, lighting setup, etc. Once again, after addressing the issues identified in the initial rehearsal, see what the final rehearsal looks like.

8. Prepare the Tip

Prepare the tip and put the tip in envelopes.

9. Trying on Wedding Shoes

In fairy tales, it is said that the prince found his princess by trying on the crystal shoes. Trying on shoes is a very necessary part of a wedding, and the only way to know if the shoes fit is to put them on.

When we buy or customize wedding shoes, we have already tried them on, but the time is also relatively short. After the shoes arrive you have to wear them for a while longer, we have to stand for a long time at the wedding, the shoes must be comfortable.

1 Month

1. Hairdressing / Manicure and Pedicure

To look more radiant on her wedding day, a bride should prepare now by making an appointment with a beauty store for a beauty salon.

In addition to her hair and face, she should also trim her fingernails and toenails and get a full body massage, which will not only relax her body and mind, but will also make her exposed skin look tighter and more radiant.

We have to pay attention to every detail of our body to make ourselves look more beautiful.

2. Trying On the Dress

Try on the dress again to see if it matches the wedding shoes and veil, and if there are any inconveniences when walking around the wedding venue.

3. Packing for the Honeymoon

Some minimalist couples prefer to go straight to their honeymoon after receiving their marriage certificate rather than having a wedding.

While most couples will still have a party, now is the time to prepare your honeymoon luggage. You can make a “Honeymoon Check List” to list all the items you need to prepare so you don’t forget them.

4. Determine the final number of wedding guests

A few days before the wedding to reconfirm the number of guests, who can attend the wedding and who cannot attend the wedding.

When the wedding date is near some guests may encounter temporary unexpected circumstances cannot attend the wedding, and some guests who cannot come and have time to attend the wedding, to determine the final number of people, adjust the seating chart to avoid “Not ready” situations on the day of the wedding.

5. Practice Your Vows

Now it’s time to practice your wedding vows. Reading them aloud will boost your mood and make you braver. You may be very excited on your wedding day and practicing your vows more often will make you calmer and less nervous on your wedding day.

One Week to One Day Before the Wedding

6. Hive A Good Rest

Eating healthy foods a few days before the wedding will make our skin look better and will prevent us from getting sick from eating greasy, spicy, or unhealthy foods that can affect our condition on the wedding day.

Drink less water the day before the wedding to prevent water retention. Sleep is also important. Although getting married may make us too excited to sleep, it is still important to get enough sleep so that we can be in better spirits.

7. Pre-wedding Preparation

Set up every corner of your bedroom backyard etc. and prepare everything you want to record. Check your wedding check list and make sure every item is completed. Put on your makeup, get dressed, and be the perfect bride and groom to start a beautiful wedding.

Wedding Planner Checklist Template

Below you will find a free editable wedding planning checklist template, which is also a wedding timeline planner, you can design your favorite wedding planning checklist spreadsheet based on these free templates we provide and finally achieve your personal wedding planning goals.

This is a free official wedding planning checklist template from Microsoft Office that allows you to complete wedding planning tasks for 9-12 months, 6-9 months, 4-6 months, 2-4 months, 4-8 weeks, 2-4 weeks, 1 week, and 1 day before and on the day of the wedding.

You can use this wedding checklist as an interactive checklist or you can print it as a PDF file so you can make notes on it whenever you want.

This template is an editable wedding planning checklist spreadsheet that you can open via Microsoft Excel spreadsheet or you can import and use it via Google Sheets.

If you like this wedding schedule planner, then you can search for the keyword “wedding schedule planner” in the Microsoft Excel program and you will see it.

This article will show you some free daily house cleaning schedule, weekly house cleaning schedule and monthly house cleaning schedule templates for google sheet and Microsoft Excel spreadsheet applications and will also explain some of the features or important functions of these templates. This will make it easy for you to make modifications when using these templates to meet your specific requirements.

Below we will share with you some free printable and editable house cleaning schedule and checklist (daily, weekly, monthly) templates. These templates can be opened and used on top of a Microsoft Excel spreadsheet or Google Sheets. They are completely free and you can print out as many copies as you need.

Why is a House Cleaning Schedule and Checklist Important?

When you find some corners of your home with dust, rust or dirt, you may just keep it in mind and after that you may forget the areas that need to be cleaned and when there are more and more areas that need to be cleaned, you may not know how to start or from which place to clean. This may add some worries in your very busy life.

Having a regular house cleaning schedule and checklist is essential if you want to have a clean home. A house cleaning schedule can help you plan exactly which areas of your home need to be cleaned on which day.

You just need to follow a daily cleaning schedule, a weekly cleaning schedule and a monthly cleaning schedule for regular cleaning and then your house cleaning will become a breeze.

Why a Clean House is Good For You

Firstly, a clean house can keep you and your family away from clutter and dirt, maintaining a clean and healthy living environment. By reducing the amount of dust or dirt that accumulates in your house, you can minimize or even completely reduce the risk of your family members getting sick. As you probably know, dust is a common cause of colds, coughs, asthma attacks and various allergic diseases. This is why a regular house cleaning is crucial to maintaining a healthy and hygienic home.

Secondly, a clean house can also relieve the stress of work and life. When you enter a dirty and messy house, your emotions will immediately feel stressed and disappointed; and when you neglect house cleaning for a long time, the accumulation of house cleaning will keep coming to your mind, which will make you more stressed.

Finally, a clean and tidy home will save you time when looking for things. With a dirty house, it can be quite frustrating when you suddenly need to find an important item. What’s more, it will make your cleaning job more difficult later on.

What Should be Included in a Cleaning Plan Checklist

When you create a house cleaning schedule checklist, you need to think about what should be included in the template. Here are some of our suggestions.

a) Living room

We recommend that you start your house cleaning task with the living room because it is the first room we will see when we enter the house, so it will be important for us to have a clean and tidy first impression.

b) Kitchen

The kitchen is one of the most difficult rooms to clean in the whole house cleaning task because it will contain greasy and swollen substances and you will need to clean the cabinets, floors, walls, hoods, etc.

c) Bedrooms

We spend most of time in our bedrooms, so the cleanliness of our bedrooms has a great impact on us.

d) Bathroom

The bathroom is also an important room for us, it is the place where you keep your body clean, and the bathroom are more humid, easy to breed mold, so this room is also a priority for us to clean.

Daily Cleaning Schedule Checklist Template

Daily cleaning may be difficult for us, we may all be busy with our lives, with our own children, or with work, then daily cleaning can greatly reduce the task load of your entire cleaning schedule, you only need 15-30 minutes a day to keep your home clean and tidy, and it won’t take away from work, or from spending time with your children or spouse and won’t take up so much of your weekend time with accumulated cleaning tasks so that your own life becomes uninteresting.

A daily cleaning schedule can list some of the cleaning tasks you need to do every day, and if you can’t do all of them every day, don’t worry, you can just do one of them every few days. Of course, you can also ask other family members to help you with some of the cleaning tasks and you may also find that they are willing to complete the items on your cleaning schedule.

Here are some free daily cleaning schedule templates that you can download and print out for free.

1.Daily Cleaning Schedule and Checklist Template by Excelhow

This template is created by google sheets, if you need to use this template by Microsoft Excel Spreadsheet, then you need to download it in xls format by google sheets first.

The template contains five main types of house cleaning, bathrooms, living areas, kitchen, bedrooms, Miscellaneous. You can add your daily cleaning tasks to the corresponding cleaning categories based on these five types.

This template is a printable and editable daily cleaning schedule template that allows you to add new cleaning categories or other more complex features.

If you have any other customization requirements, then leave us a comment.

Click here to use this template.

2. House Cleaning Checklist For Daily Cleaning by Microsoft Office

This template is the official house cleaning checklist template provided by Microsoft Office and you need to open it via Excel. If you need to use this template in Google Sheets, then you can visit this address.

This template is simple, there is no categorization of cleaning matters, you just need to write down the things you need to do every day on the list.

You can use this house cleaning checklist template to organize and track your house cleaning schedule, it also includes daily, weekly, monthly and seasonal house cleaning checklists. Use this cleaning checklist template to organize your house cleaning tasks such as laundry, dishes, etc. This is a hassle-free house cleaning template checklist.

Click here to use this template.

Weekly Cleaning Schedule And Checklist Template

Cleaning one room a day or completing one big cleaning task so that you don’t do everything at once, such as dedicating Mondays to cleaning kitchen clutter or greasy stains, Tuesdays to cleaning bedrooms, etc.

It’s important to clean the major rooms in your house each week, even if they don’t look dirty. This cleaning schedule list can help keep your house clean to the greatest extent possible.

After you execute it for a few weeks, you will find that it will take you very little time to complete the cleaning task, because after our continuous cleaning, the house is not so dirty anymore, and when we clean it again, it will become less time consuming and less effort. And another great benefit is that a clean and tidy house will make you feel significantly less anxious.

Here are some free weekly cleaning schedule checklist templates that you can download for free and print out to use.

1.Weekly Cleaning Schedule and Checklist Template by Excelhow

This template was designed by ExcelHow and can be downloaded and printed for free or you can customize it based on it. By default, the template needs to be opened via google sheets, but if you need to use the template via Microsoft Excel Spreadsheet, then you need to download it locally in .xls format.

The template splits the weekly cleaning schedule into six days, which makes them look less cluttered and more manageable. It is better to do just a few things each day rather than spending hours around the house trying to do all the cleaning tasks at once.

If you have any other personalized customization needs, then leave us a comment.

Click here to use this template.

2. House Cleaning Checklist For Weekly Cleaning by Microsoft Office

This template is an official house clearance checklist template provided by Microsoft office, you need to open it through Microsoft Excel. If you need to use this template in Google sheets, then you can either import the Excel template directly into google sheets, or you can also use the template at this address.

This template is quite simple, there is no splitting of the overall cleaning tasks and there is no identification of the day when the cleaning tasks are scheduled to be done, so you need to add the weekly cleaning tasks to the list and then you can make a general plan in the notes to determine the approximate day when the corresponding things will be done.

Click here to use this template.

3.Free Printable Cleaning Schedule by freebiefindmon

This template was designed by freebiefindingmon and the overall structure of the template is similar to the first template. The template is available in both doc and pdf printable versions, so if you have a personalized requirement, then you can open the doc version via google docs or Microsoft Docs and change the template according to your own needs.

Click here to use this template.

4.Puracy Weekly House Cleaning Checklist

This template was designed by puracy and the overall structure of the template is similar to the first one. The template is only available in pdf printable version, so you can’t make any personalized changes to it.

If you like this template, you can change it based on the first template, for example, the background color, the checkbox layout, etc.

Click here to use this template.

5. House Cleaning Schedule and Checklist by Vertex42

This template was designed by Vertex42 and contains a 4 week cleaning schedule list with different cleaning tasks broken down by 6 days each week.

This template is especially useful for situations where you have different house cleaning tasks every week, so you can plan in advance the cleaning schedule tasks you need to do for the next 4 weeks. Of course, it can also be used in situations where the cleaning tasks are the same every week, and you can print it out and use it to keep track of the weekly execution.

Click here to use this template.

Monthly Cleaning Schedule And Checklist Template

A monthly cleaning list is used to deep clean items that are used frequently or to eliminate items that we don’t clean often and may not use anymore.

We recommend that you prioritize the tasks that need to be cleaned each month by using the following methods. The first method is to start with the less visible areas of your home, such as under the bedroom bed and on top of the cabinets, which are rarely seen on a daily basis and are often forgotten during daily or weekly cleaning. may be overlooked, such as door handles.

Some cleaning items that could be included in a monthly cleaning schedule list:

• Refrigerator top
• Refrigerator interior
• Top of cabinets
• Closet interiors
• Ceiling fans
• Light fixture
• Skirting
• Door frame
• Furniture rear
• Shower curtain
• Bathroom faucets, spray nozzles
• Window curtains
• Washing machine interior

Here are some free monthly cleaning schedule checklist templates that you can download and print out to use for free.

1.Monthly Cleaning Schedule and Checklist Template by Excelhow

This template was designed by ExcelHow and can be downloaded and printed for free or you can customize it based on it. By default, the template needs to be opened via google sheets, but if you need to use the template via Microsoft Excel Spreadsheet, then you need to download it locally in .xls format.

The template contains 5 types of cleaning items, you can add the items that need to be cleaned to the corresponding item list category according to the actual situation of your home. If you have other types of cleaning items, you can add them yourself as needed. You can also change or add specific items based on the current template.

If you have any other customization needs, then you can send us a message.

Click here to use this template.

2. House Cleaning Checklist for Monthly Cleaning by Microsoft Office

This template is an official house cleaning checklist template provided by Microsoft office, you need to open it via Excel. If you need to use this template in Google sheets, then you can either import the Excel template directly into google sheets or you can use the template through this address.

Click here to use this template.

3. House Cleaning Schedule and Checklist by Vertex42

This template was designed by Vertex42 and contains a list of daily, weekly and monthly cleaning schedules and is recorded according to different cleaning item types.

This template is suitable for house cleaning schedules with the same cleaning tasks on a daily, weekly and monthly basis.

This template needs to be opened by google sheets by default, if you need Microsoft Excel to open it, you need to download it locally and then use it.

Click here to use this template.

4. Home Cleaning Checklist by SHEA HOMES

This template is provided by SHEA HOMES Design. The template is similar in design structure to template 3 and is also a house cleaning schedule list containing daily, weekly and monthly cleaning tasks. The template also keeps track of the items that need to be cleaned according to the different areas of your home.

You can download and print out this house cleaning schedule list for free and stick it to the areas you can see every day, such as the refrigerator door or the bathroom door.

Click here to use this template.

Time-saving daily cleaning tips

• Finally, I’d like to share with you some cleaning tips for everyday life. By following these cleaning habits and tips, you can save a lot of time you spend on your daily, weekly or monthly cleaning tasks.
•  Keep the sink free of dirty dishes before bedtime
• Make your bed when you get up
• Hang up or put away the clothes you wear each day
• Keep the sink or mirror clean after washing your face
• Clean up the kitchen when you cook
• Keep the floor cleaner by not wearing shoes when you enter the house
• You can buy a robot vacuum for daily cleaning
• Keep clutter away from kitchen counters for easy wiping
•  After showering, rinse the sides, shower seat or bathroom glass door with the showe

This article will talk about how to sort the specified data in google sheets according to the number of occurrences? How to use google sheets RANK function to sort a given cell range by the number of repetitions of a value?

Rank Data by the Number of Occurrences

Suppose you have a task that needs to be ranked according to the number of occurrences. How to sort the data in a given cell range by the number of repetitions in google sheets.

First you need to count the number of occurrences of the values in the given data range, and then use the RANK function to sort the data. You can follow the steps below.

Step 1: You first need to copy the list of data and paste it into another data column as follows.

Step 2: Select “Data” Tab and click on the “Data CleanUP” menu, then clicking “remove duplicates” sub menu. The “Remove Duplicates” window will pop up.

Step 3: Click the “Remove duplicates” button and then click the “ok” button, which will remove all duplicate values and keep only one of each value.

Step 4: You can use the following COUNTIF formula to get the number of duplicates of the values in the cell area A1:A8, then press the Enter key and drag the AutoFill Handler until cell D5, so you can easily apply the formula.

=COUNTIF($A$1:$A$8,C2)

Step 5: You need to use the google sheets RANK function in cell E2 to sort the number of repetitions of the values counted in the previous step, after that press the Enter key and drag the Auto Handler until cell E5.

=RANK(D2,$D$2:$D$5)

Now you can see the result of ranking by the number of repetitions of the value has been calculated.

Related Functions

---

• Google Sheets RANK Function
  The Google Sheets Rank function is used to return the ranking of a given number from a list. If there are duplicate numbers in the list, then the numbers will be in the same rank.The syntax of the Google Sheets Rank function is explained as follows:The syntax of the Google Sheets Rank function is explained as follows:= RANK (number,reference ,[order])…
• Google Sheets COUNTIF function
  The google sheets COUNTIF function is used to count the number of cells in a cell range that meet a given condition.The syntax of the Google Sheets COUNTIF function is explained as follows: = COUNTIF (range, criteria)…

This post will guide you how to count numbers that begin with a specific value or number in Excel 2013/2016 or Excel office 365. How do I count the number of values that begin with a given specific value by using the SUMPRODUCT function and LEFT function in Excel. You can also use the COUNTIF function to count cells that begin with certain characters in Excel.

Assuming that you have a data of list in range B2:B6, and you want to get how many cells in your list which begins with a given number. For example, you wish to calculate the count of number in list where the values begin with “2020”.

Method1: COUNT Numbers that Begin with Specific Value

---

To count numbers in your range of list that begin with specific numbers, and you can use a formula based on the SUMPRODUCT function and LEFT function.

=SUMPRODUCT(–(LEFT(B2:B6,4)=”2020″))

Let’s See That How This Formula Works:

=LEFT(B2:B6,4)

This formula will extract the first 4 characters from the given range of cells. And it returns an array result like:

{“2019″;”2020″;”2020″;”2021″;”2023”}

=LEFT(B2:B6,4)=”2020″

The above array result will compare each value to “2020” to generate a TRUE or FALSE result. And this formula also returned as an array result of TRUE and FALSE values. Like this:

{FALSE;TRUE;TRUE;FALSE;FALSE}

=–(LEFT(B2:B6,4)=”2020″)

Then you need to use a double negative operator to convert TRUE or FALSE values to 1 and 0. It also returned an array result like:

{0;1;1;0;0}

SUMPRODUCT function sums the numbers in the above array and returns 2.

Method2: COUNT Numbers that Begin with Specific Value Using COUNTIF Function

---

You can also use the COUNTIF function to count the numbers that begin with a particular value. Like below:

=COUNTIF(B2:B6,”2020*”)

This formula use the asterisk wildcard to match any number of uncertain characters in length in your given range of cells.

#1 select Cell D3

#2 enter the above formula into Cell D3

Then you need to press Enter key to apply this formula.

Related Functions

---

• Excel SUMPRODUCT function
  The Excel SUMPRODUCT function multiplies corresponding components in the given one or more arrays or ranges, and returns the sum of those products. The syntax of the SUMPRODUCT function is as below:= SUMPRODUCT (array1,[array2],…)…
• Excel COUNTIF function
  The Excel COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks, or containing specific characters.etc.= COUNTIF (range, criteria)…
• Excel LEFT function
  The Excel LEFT function returns a substring (a specified number of the characters) from a text string, starting from the leftmost character.The LEFT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.The syntax of the LEFT function is as below:= LEFT(text,[num_chars])…t)…

In statistic, to create a yearly report for showing the market trend on different years, we often sum a total for different years, so based on the year’s total we can do estimation for the coming year. This scenario frequently occurs at the end of a year. If data for different dates and years are disordered in a table, how can we pick them up by year and sum total for the year correctly only by applying a formula?

To resolve this problem, we can apply Excel’s SUMIFS function and DATE function. SUMIFS function is used for sum data after filtering data based on provided criteria. Actually, it can provide multiple criteria ranges and criteria to filter data, user can sum up data based on them properly. DATE function is used for returning a date form by the given values or cell reference. Above all, we can combine the two functions into one formula to sum data by year properly.

In this article, we will show you the formula which can ‘sum data by year’ based on SUMIFS function and DATE function. To illustrate SUMIFS and DATE functions clearly, we will introduce them with their basic syntax, arguments introduction, simple usage descriptions with screenshots and explanations. In this article, we will introduce the formula from inside (DATE) to outside (SUMIFS), explain each argument in the formula, also show you the formula’s work process step by step, thus you can understand it deeply. After reading the following article, I’m sure you can learn well about SUMIFS and DATE functions, and apply them to solve your problem properly in the future.

EXAMPLE:

In the left table, column A lists dates in different years, column B lists product serial number P00001 and P00002, and column C lists the amount of different products on different dates and years respectively; in the right table, column E lists Year information, column F is used for recording the total amount on each Year. To calculate total amount based on year, obviously we should filter date by year, and then sum up amount values based on filtered date. For example, for cell E2 year 2018, firstly we should filter out date which is in year 2018 in column A, in this case A2, A3, A8 and A9 are filtered, then sum up C2, C3, C8 and C9. In this instance, to calculate the total amount for each year, we will apply SUMIFS and DATE function to sum data.

FORMULA APPLICATION

Step 1: In F2, enter the formula =SUMIFS($C$2:$C$13,$A$2:$A$13,”>”&DATE(E2,1,1),$A$2:$A$13,”<“&DATE(E2,12,31)).

Step 2: Press Enter after typing the formula.

In this instance, dates in A2, A3, A8 and A9 belong to year 2018, so amounts in C2, C3, C8 and C9 should be summed. The total equals to 100+84+90+75=349. The formula works correctly.

Step 3: Apply the formula to F3 and F4. Just drag the handle down to apply this formula in F3 and F4 Verify that after dragging, the formula is updated to =SUMIFS($C$2:$C$13,$A$2:$A$13,”>”&DATE(E3,1,1),$A$2:$A$13,”<“&DATE(E3,12,31)) in F3. And value 293 is returned after pressing Enter.

Dates in A4, A5, A10 and A11 belong to year 2019, so amounts in C4, C5, C10 and C11 should be summed. The total equals to 60+55+88+90=293. The formula still works correctly.

Step 4: Let’s check the formula in F4. The formula is =SUMIFS($C$2:$C$13,$A$2:$A$13,”>”&DATE(E4,1,1),$A$2:$A$13,”<“&DATE(E4,12,31)), total is 305. It equals to 78+82+75+70.

FUNCTIONS INTRODUCTION:

For this formula =SUMIFS($C$2:$C$13,$A$2:$A$13,”>”&DATE(E2,1,1),$A$2:$A$13,”<“&DATE(E2,12,31)), we applied two functions SUMIFS and DATE.

DATE FUNCTION:

DATE function can return a serial number that can represent a particular date if current cell format is ‘General’ or directly return a date if current cell format is ‘Date’. The syntax is

DATE(year,month,day)

All the three arguments ‘year’,’month’,’day’ are required. Please see some examples below to see the usage of DATE function.

Enter =DATE(2020,11,12) in any cell, then 11/12/2020 is returned in date format.

If you want to return a serial number, you can change cell format to ‘General’ via Home->Number ->General, then a number which can represents a date is displayed instead. Date 11/12/2020 is converted to 44147. On the other side, if you get 44147 after entering =DATE(2020,11,12), you can also select ‘Date’ in Number dropdown list to convert it to date. Please be aware that, in a formula DATE returns a serial number instead of date.

You can also save arguments in different cells, then enter cell reference into DATE function, see example below:

If month number is greater 12, for example 14, then 14-12=2, February of the next year will be returned. Date has the same behavior if date is greater than 31. See example below:

SUMIFS FUNCTION:

SUMIFS function can be seen as SUM+IFS, it supports multiple ‘criteria range’ and ‘criteria’ combinations.

For SUMIFS function, it has below arguments:

SUMIFS(sum_range, criteria_range1, criteria1,

[criteria_range2, criteria2]

, …). Criteria range2 and criteria2 are optional, so it still works if only one criteria range and one criterion exist. For the usage of SUMIFS function, we will split the formula to several parts, and let you know how this formula works with SUMIFS function from inside to outside.

HOW FORMULA WORKS:

=SUMIFS($C$2:$C$13,$A$2:$A$13,”>”&DATE(E2,1,1),$A$2:$A$13,”<“&DATE(E2,12,31))

In this formula:

1. ‘$C$2:$C$13’is the first argument ‘sum range’, it lists all amounts, after filtering data based on provided criteria, we pick up data from this range to sum up in the last step. As we also want to apply the formula into other cells, so we add $ before column and row to lock the range. You can see that, in former part Formula Application step#3, when copying formula to F3 and F4, this range is fixed.

In formula bar, we can convert range or executed result to actual number or array by pressing F9 in some cases. In this case, the sum range $C$2:$C$13 = {100;84;60;55;78;82;90;75;88;90;75;70}

2. ‘$A$2:$A$13’is the second argument ‘criteria_range1’. It lists dates in different years. We still add $ before column and row to lock the range.

The first criteria range A2:A13 = {43420;43450;43785;43815;44151;44181;43420;43450;43785;43815;44151;44181}.

Here we can see that date format is converted to number, each serial number represents a date. I think you are getting to know why we use DATE function in criteria argument to filter date later.

3. “>”&DATE(E2,1,1) is the argument ‘criteria1’. SUMIFS function supports logical symbols like “>”,”<” or “=”, we just need to add double quotes “” to enclose them.

DATE(E2,1,1) returns 43101. It represents date 1/1/2018, the start date in year 2018. “>”&DATE(E2,1,1) means date greater than 1/1/2018, in the formula it is “>43101”, which means number greater than 43101.

4. ‘$A$2:$A$13’is also the fourth argument ‘criteria_range2’.

5. “<“&DATE(E2,12,31) is the argument ‘criteria2’.

DATE(E2,12,31) returns 43465. It represents date 12/31/2018, the end date in year 2018. “<“&DATE(E2,12,31) means date less than 12/31/2018, in the formula it is “<43465”, which means number less than 43465.

Above all, the formula in E2 can be seen as below:

=SUMIFS({100;84;60;55;78;82;90;75;88;90;75;70},{43420;43450;43785;43815;44151;44181;43420;43450;43785;43815;44151;44181},”>43101″,{43420;43450;43785;43815;44151;44181;43420;43450;43785;43815;44151;44181},”<43465″)

In this formula, refer to the first group of criteria range and criteria ({43420;43450;43785;43815;44151;44181;43420;43450;43785;43815;44151;44181},”>43101″), number which is greater than 43101 will be saved as True (others are False) in the array:

{True,True,True,True,True,True,True,True,True,True,True,True }

And refer to the second group of criteria range and criteria ({43420;43450;43785;43815;44151;44181;43420;43450;43785;43815;44151;44181},”<43465″), data which is less than 43465 will be saved in the array.

{True,True,False,False,False,False,True,True,False,False,False,False}

Then compare the two arrays and keep ‘True’ for those both are True in two arrays.

{True,True,False,False,False,False,True,True,False,False,False,False}

Convert ‘True’ to ‘1’ and ‘False’ to ‘0’:

{1,1,0,0,0,0,1,1,0,0,0,0}

After filtering data by two criteria, make sure that below two arrays are vertically alignment.

Array1: {100;84;60;55;78;82;90;75;88;90;75;70} – sum range

Array2: {1,1,0,0,0,0,1,1,0,0,0,0}) – criteria

Keep current value in array1 if its corresponding value is 1 in array2, otherwise value is changed to 0. You can also think value in array1 multiplies the corresponding value in array2. Thus, we can get another array:

Array3: {100;84;0;0;0;0;90;75;0;0;0;0} – sum range

Sum data in array3, 100+84+90+75=349.

The formula work process is the same for F3 and F4.

Related Functions

• Excel DATE function
  The Excel DATE function returns the serial number for a date.The syntax of the DATE function is as below:= DATE (year, month, day)…
• Excel YEAR function
  The Excel YEAR function returns a four-digit year from a given date value, the year is returned as an integer ranging from 1900 to 9999. The syntax of the YEAR function is as below:=YEAR (serial_number)…