Removing holidays and weekends , networkdays

A

amyk1313

I'm trying to use this function but it keeps returing the number of
actual days, its not removing the weekends or holidays that I put in.

one column date format is in yyyy-mm-dd, the othe rin mm/dd/yyyy
I tried changing to both mm/dd/yyyy but didn't help.

Can anyone help me?
 
B

Bob Phillips

Give us the data and the formula you tried. It sounds like one of them is
text, not being recognised as a date.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
counting records by month and year / date format issues 1
Formula ... Minus Holidays? 1
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Excel - convert dates to text but appear as a date format 6
Sumproduct and Date format 1
About mail merge 1

Top