date functions

G

Guest

The workday formula works as noted in my previous question but I'm having
trouble trying to exclude the holidays. I have a list of them but cannot get
the datevalue function to convert it. Suggestions welcomed.
 
P

Paul Sheppard

VDan said:
The workday formula works as noted in my previous question but I'm
having
trouble trying to exclude the holidays. I have a list of them but
cannot get
the datevalue function to convert it. Suggestions welcomed.
Click to expand...

Hi VDan

Type the date into any cell and then format it as a number, this will
give you the number to enter for holidays
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In WORKDAY function, how to exclude multiple/variable holiday rang 4
Date + X days excluding holidays 1
Date Range 4
Schedule to exclude weekends and holidays 3
workday formula question 3
Calculate the number of days to exclude Sunday & Holidays 6
How to shift a weekend date to the last or next workday 2
Connecting multiple IF statements into one formula 2

Top