Excel – is it a working day?

Need to know if a date is a working day? Excel has a WORKDAY function which takes a date, adds to it, and tells you the next working day. What about if a specific day is a working day? Assuming the date is in A1:

=WORKDAY((A1-1),1)

Leave a Reply

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