Excel WORKDAY Function | how to to calculate things like ship dates, delivery dates, completion

Summary | details

That Excel WORKDAY function takes a date and returns it nearest working day n days in the future or past. You can use the WORKDAY function to calculate things like ship dates, delivery dates, and completion dates that need to take into account working and non-working days.

Purpose | goals
Get a date n working days in the future or past
Return value
A serial number representing a particular date in Excel.
Syntax
=WORKDAY (start_date, days, [holidays])
Arguments
start_date - The date from which to start.
days - The working days before or after start_date.
holidays - [optional] A list dates that should be considered non-work days.

Тэги:

#excel_formulas #excel_functions #excel #excel_formulas_and_functions #microsoft_excel #excel_tips_and_tricks #excel_tutorial #functions_in_excel #functions #learn_excel #excel_for_analysts #excel_formulas_and_functions_tutorial #excel_online_course #ms_excel #new_excel_functions #how_to_do_excel_functions #advanced_excel_functions #excel_if_function #function #excel_let_function #excel_tips #advanced_excel_tricks #excel_crash_course #excel_training #excel_basics

Скачать видео