قالب وردپرس درنا توس
Home / Tips and Tricks / Use DATE, WEEKDAY, IF, and / OR from Excel to create weekly schedules by task, event, and team member

Use DATE, WEEKDAY, IF, and / OR from Excel to create weekly schedules by task, event, and team member



Excel's SUM, DATE, WEEKDAY, IF, Nested IF, and IF / OR functions came to my mind when I saw a 1969 movie titled . If it is Tuesday, this must be in Belgium, about American tourists a whirlwind tour of Europe. I get the impression that companies often need to create schedules based on the weeks (as opposed to the days) of a month – for example week 1, week 2, week 3, etc. This would require the use of a date formula to run every week in Identify a system one month and a series of nested IF / OR statements to assign tasks and team members to perform these tasks. Using Excel as a scheduling tool is a great skill you can afford.

Imagine you are working for a magazine covering sports events around the world, and it is up to you to set the timetable for the journalists and videographers who relate to those events. For example, on the third Tuesday of each month, figure skating is organized and the place is Belgium. The fourth Tuesday is in Scotland The first Thursday is golf in Ireland. and last Thursday it's rugby in New Zealand. The following formulas can make this cumbersome, time-consuming task a simple, quick, and easy task.

We've added a downloadable spreadsheet that lets you practice these skills:

Download

Table to learn the following functions: DATE, WOEKDAY, IF, and IF / OR. JD Sartain

Formulas / functions used in this article

1. SUM

Syntax: = SUM (A2: A10); = SUM (4 + 5); = SUM (A2 + A3) -A4; = SUM (A2-A3) + (A4-A5)

Define: The SUM function is very versatile. It allows you to add, subtract, multiply, divide, and / or perform dozens of other calculations.

. 2 DATE

Syntax: = DATE (year, month, day)

Define: Provides a date based on three values: year, month, day.

. 3 WEEKDAY

Syntax: = WEEKDAY (serial number, [return_type])