How to make a work calendar for sharing team tasks

Method Step 1

Create a blank Excel document.

Then enter the date in the first column, followed by the date in the second column.

Select the second column, and then right-click and select Format Cells

Select "Custom" in "Number", enter "aaaa" in the generic type, and then click OK. So there is a day of the week.

Next, enter the to-do items in the third column.

end method two.

After the date is entered in the first column, the to-do items are entered in the second column.

Select the first column and click on "Formatting" on the menu - "Conditional Formatting".

Select "Formula" in condition 1, and then enter =weekday($a 2,2)>5, [$a 2 means the referenced cell, 2 means Sunday=1, to Saturday=7. Representation of "5", pick it out. You can choose the format

Select Format, > bold for 5, and the unit grid in yellow.

Click "OK" and you're good to go. In this way, week 5 and week 6 will be bolded.

There are a lot of software to choose from for team work, and Dedication Sign is one of the best of them.

1. Dedication sign is a more comprehensive desktop note software, divided into individual notes and team collaboration notes, and all team members can see the content recorded in the team notes at a glance.

2. Managers can also set the assignment mode of the recorded content according to their own work needs, so that the designated members can receive reminders at the specified time.

3. After completing the task, the assignee can also mark the content as completed, and all the work processes are clear at a glance, saving a lot of unnecessary trouble.

Figure 1 Working calendar**.

In this **, some work needs to be carried out on weekly holidays, and if all weekly holidays can be conspicuously marked, some scheduling problems can be avoided. This requirement can be easily achieved using conditional formatting in the following ways.

Click A2 and drag the cursor to A17 to select the area A2:A17, click the menu "Formatting" "Conditional Formatting".

In the Conditional Formatting dialog box, click the drop-down arrow for Condition 1(1), select the Formula item in the list, and enter the formula in the text box on the right

weekday(a2,2)>5

Click the Format button, select Glyph as Bold and color as red in the Font tab of the Format Cells dialog box, and click OK.

Figure 2 Conditional Formatting dialog box.

Once set, ** for all weeks.

The above formula uses the function weekday to calculate the week of the active cell, if it is greater than 5, it is Saturday or Sunday. According to this idea, conditional formatting can also be used to display Saturday and Sunday in different colors, and readers can try it out for themselves.

Figure 3 Highlights the work calendar for weekly holidays.

It is recommended that you use a calendar desktop, life calendar, its note-taking function is very powerful, and it is good to customize reminders, which is very convenient.

Then it's better to find the Calendar + Schedule desktop plugin.

Whether it goes back and forth.

Now there are many calendar templates in Word, we can create a new calendar document in Word to complete the operation of making a calendar, the specific operation can be referred to as follows.

1. The Office software used in this demonstration operation is Word 2013 version.

2. First of all, open the word document and create a new word to demonstrate how to make a calendar table in word.

3. Find the File tool in the menu bar and click Open.

4. Select the New option under the menu bar of the file that opens.

6. In this way, a new calendar has been created in the word document.

1. Create a new word document, as shown in Figure 1 below; In the navigation bar on the right, find "Template on the machine", that is, it is created according to the template of the machine, as shown in Figure 2.

2. Click to open the local template, the template dialog box appears, as shown in Figure 1, find the "Other Documents" tab, select "Calendar Wizard" from it, as shown in Figure 2 below, after selection, click "OK";

3. The system automatically enters the calendar wizard; Click Next directly;

4. Choose a favorite style in the calendar style, the system provides three styles by default, namely Standard, Banner, Excellent, Select Standard, click Next;

6. In the "Date Range" option, you want to make a date range for the calendar to set, for example, enter: January 2004 to December 2004, in the "Do you want to print the lunar calendar and solar terms?" below. Yes, or you can select No as needed; Click Next after setting it up;

7. Click Done, and a calendar is ready.

8. You can set the background of the calendar according to your needs, click "Format" - "Background", and select a background color, as shown below;

Create a calendar with word 2003:

Create a new Word document, and find "Template on the machine" in the navigation bar on the right, that is, create it according to the template of the machine;

Click to open the native template, the template dialog box appears, find the "Other Documents" tab, select "Calendar Wizard" from it, select it, and click "OK";

The system automatically enters the calendar wizard; Click Next directly;

In the "Date Range" option, you want to make a date range for the calendar to set, for example, enter: January 2004 to December 2004, under the "Do you want to print lunar calendars and solar terms?" Yes, or you can select No as needed; Click Next after setting it up;

Click Done, and a calendar is ready.

Insert the text box first, horizontally, and then point the cursor into the text box, insert **, 14 rows, 4 columns, and then hide the text box, right-click the border and shading (choose your favorite), and then fill the color plus the date and week, add **, WordArt, and that's it.

Files, new creations, templates on the machine, other documents, calendar wizards, just learn to do it step by step.

Make a calendar that can represent the month, day, and year at the same time

The specific steps to make a calendar worksheet with excel are as follows:

1. First of all, in the excel sheet, click "File", and then click "New".

3. Select and click on the 12-month calendar to create a template.

4. In the corresponding blank space below each date, double-click to enter reminders as needed.

5. In the end, we only have a calendar with work items.

Method Step 1

1. Create a blank excel document.

2 Then enter the date in the first column, followed by the date in the second column.

3Select the second column, and right-click to select "Format Cells".

4. Select "Custom" in "Number", enter "aaaa" in the general type, and then click OK. So there is a day of the week.

5. Next, enter the to-do items in the third column.

end method two.

After the date is entered in the first column, the to-do items are entered in the second column.

Select the first column and click on "Formatting" on the menu - "Conditional Formatting".

Select "Formula" in condition 1, and then enter =weekday($a 2,2)>5, [$a 2 means the referenced cell, 2 means Sunday=1, to Saturday=7. Representation of "5", pick it out. You can choose the format

Select Format, > bold for 5, and the unit grid in yellow.

Click "OK" and you're good to go. In this way, week 5 and week 6 will be bolded.

It's similar to what we usually do worksheets, as long as the format is designed and typed, of course, it takes some time to do.

Method: 2. Drag the scroll bar on the right in the pop-up "Other Controls" dialog box until you find "Microsoft Date and Time Picker Control", and then click OK, as shown in the following figure

3. Then click the left mouse button and drag it left and right to insert a calendar control, at this time the "control" working group is in "design mode", and the calendar control is still in design mode at this time, and it cannot be used, as shown in the following figure:

4. Click the "Design Mode" button, uncheck the status, and the calendar control can be used. As shown in the figure below:

We know that adding one to one date gives you the next date, see the attachment for details.

Do you want to do something simple, or something complex, and you need to use functions

There are ready-made ones on the top, just change them to the way you need them.

You can also DIY the calendar with word, and you can also set it according to your preferences, which is completely exclusive and easy to operate!

Tutorial Tweet web link.

Why do you want to make your own calendar, now some calendar software custom settings are very powerful, very personalized, my own life calendar is like this, very easy to use, recommended to you. Hee-hee.