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

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



Excels SUM, DATO, WEEKDAG, IF, Nested IF and IF / OR features came in mind when I watched a 1969 movie called If it's Tuesday, this must be Belgium, about American tourists on a whirlwind tour in Europe. It occurred to me that companies often have to create schedules based on the weeks (as opposed to the days) for a month – such as week1, week2, week3, etc. This would mean using a date formula to identify each week in a given month, plus a series of recent IF / OR rates to assign tasks and team members to complete these tasks. Using Excel as scheduling tools is a great skill to wear under your belt.

Imagine working for a magazine that covers sporting events all over the world, and it's your job to create schedules for journalists and videographers that cover these events. For example, on the third Tuesday of a certain month, the event is ice skating and the place is Belgium; The fourth Tuesday is the bobsledding in Scotland; The first Thursday there is golf in Ireland; and last Thursday it is rugby in New Zealand. The formulas below can make this difficult and time-consuming task a simple, quick and easy task.

We have included a downloadable spreadsheet that you can use to exert these skills:

Download

Spreadsheets to learn the following features: DATE, WEEKDAY, IF, and IF / OR. JD Sartain

Formulas / Features Used In This Article

1. SUM

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

Define: The SUM function is quite versatile. It can be used to add, subtract, multiply, divide and / or perform dozens of other calculations.

2nd DATE

Syntax: = DATE (year, month, day)

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

3rd WEEKDAY

Syntax: = WEEKDAY (serial_number, [return_type])


Source link