Formula to work out next workday after date

[skeeeter56]

Hi just cant get this formula correct.
I need to check a date in a cell then work out the next workday, I have a list of holiday dates in a list.

=WORKDAY(EndDate,1,Holiday)

EndDate is the cell that contains the date and is a Range and is on a different sheet and Holiday is the list of the holiday dates.

I end up with #VALUE as the result.

 

[Dave Smith]

Hi,
Can you pl. elaborate more ? I think i can help you in this getting solved

Regards
Dave

 

[bebo021999]

Is EndDate real date? Or is it a text value?
Try to test:
=isNumber(EndDate)
If text value, you may need to add +1
=WORKDAY(EndDate+1,1, Holiday)

 

[skeeeter56]

Hi,
Can you pl. elaborate more ? I think i can help you in this getting solved

Regards
Dave

The cell EndDate contains a date, what I need to do is workout the next working day date, taking into account some public holidays they are stored in a list Holiday

 

[skeeeter56]

Is EndDate real date? Or is it a text value?
Try to test:
=isNumber(EndDate)
If text value, you may need to add +1
=WORKDAY(EndDate+1,1, Holiday)

The result of that is True

 

[MARK858]

Can you do the same test on the holiday dates please

 

[bebo021999]

Try to test without holiday first:

=WORKDAY(EndDate,1)

Does it work?

 

[skeeeter56]

Try to test without holiday first:

=WORKDAY(EndDate,1)

Does it work?

Yes that works gives me the Monday.

 

[skeeeter56]

Can you do the same test on the holiday dates please

Yes that also gives me a True

 

[bebo021999]

Pls provide an image/screenshot to see what happenned.