From
exceljet.net
Email Address
contact@exceljet.net
Sent On
Fri, May 31, 2024 01:02 PM
Email Preheader Text
Hi - Dave here. Happy Friday! What is a workday in Excel? The main way to answer that question is th
HTML
Hi - Dave here. Happy Friday! What is a workday in Excel? The main way to answer that question is the WORKDAY function. WORKDAY is designed to return a date in the future or past that is a given number of working days from a start date, excluding weekends and any holidays you specify. The way WORKDAY works can be confusing because it's hard to see a calendar in your head when you are looking at a formula. I wanted to visualize this process and, naturally, I wanted to use Excel to do it :) I came up with the worksheet below, where the WORKDAY function is used to calculate a date 5 working days after the date in B5. The formulas in G5 and G6 show the result with and without the holidays in B11:B13: =WORKDAY(start,days)
=WORKDAY(start,days,holidays) [Visualizing how WORKDAY works]( [[Download the workbook and read the full explanation](] The start date, days, and holidays are in column B and can be changed as desired. Column G shows the result of adding 5 days with and without holidays. Columns D and E are dynamically generated and exist only to visualize which dates WORKDAY is excluding (shaded in gray), and which dates are final results (highlighted in yellow). These colors are applied with conditional formatting so these columns will update automatically when inputs change. Download the workbook and try it out yourself. Excel formulas We maintain a list of over 500 working formulas [here](. If you need more structure, we also offer [video training](. Have a great weekend! Dave [View this email in a browser]( [Exceljet Logo]( Exceljet
P.O. Box 4804
Salt Lake City, UT 84110 Copyright © 2024 Exceljet, All rights reserved.
You received this email because you are subscribed to our newsletter.
To unsubscribe, click the link below. [Unsubscribe](
EDM Keywords (51)
yellow
worksheet
workday
workbook
without
wanted
visualize
used
unsubscribe
try
subscribed
structure
specify
see
return
result
received
read
question
process
past
newsletter
need
naturally
maintain
looking
list
link
holidays
head
hard
gray
g5
future
formulas
formula
exist
excel
email
designed
dates
date
confusing
columns
colors
changed
came
calendar
calculate
b5
applied
answer