Home / Gaming / Use Excel's DATE, WEEKDAY, IF, and IF/OR to make weekly schedules by task, event and team member

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

Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR purposes got here to thoughts as I used to be looking at a 1969 movie known as If It’s Tuesday, This Will have to Be Belgium, about American vacationers on a whirlwind excursion of Europe. It happened to me that businesses are ceaselessly required to create schedules in response to the weeks (versus the times) in a month—as an example week1, week2, week3, and so forth. This may entail the usage of a date components to spot each and every week in a given month, plus a chain of nested IF/OR statements to assign duties and workforce individuals to finish the ones duties. The usage of Excel as a scheduling device is a smart talent to have underneath your belt. 

Believe that you simply paintings for that covers wearing occasions far and wide the sector, and it’s your activity to create the time table for the newshounds and videographers that duvet those occasions. For instance, at the 3rd Tuesday of a given month, the development is work skating and the positioning is Belgium; at the fourth Tuesday, it’s bobsledding in Scotland; at the first Thursday, it’s golfing in Eire; and at the remaining Thursday, it’s rugby in New Zealand. The formulation underneath can flip this bulky, time-consuming chore right into a easy, fast and simple process.

We’ve integrated a downloadable spreadsheet you’ll use to follow those talents: 


Spreadsheet for finding out the next purposes: DATE, WEEKDAY, IF, and IF/OR. JD Sartain

Formulation/purposes used on this article

1. SUM

Syntax: =SUM(A2:A10); =SUM(four+five); =SUM(A2+A3)-A4; =SUM(A2-A3)+(A4-A5)

Outline: The SUM serve as is relatively flexible. It may possibly used so as to add, subtract, multiply, divide, and/or carry out dozens of alternative calculations.


Syntax: =DATE(yr,month,day)

Outline: Supplies a date in response to 3 values: yr, month, day.

three. WEEKDAY

Syntax: =WEEKDAY(serial_number, [return_type])


About thebreakingnewsheadlines

Check Also

How to protect yourself from online scams including ransomware and more

Protective your self from on-line scams is a reality of existence now. In step with …

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: