PDA

View Full Version : evaluate a date with vba



ids_73
05-07-2017, 11:39 AM
hi there
how to evaluate a date with vba?

i want to be a working date and not a holiday.


any ideas
thanks in advance
ids

Bob Phillips
05-07-2017, 11:44 AM
Explain exactly what you mean by evaluate.

SamT
05-07-2017, 11:51 AM
Dim Found as Range
Set Found = Range(ListOfHolidays).Find(MyDate)
If Found is Nothing Then MyDate <> Holiday

snb
05-07-2017, 12:34 PM
Are you retired or ? :whistle:

SamT
05-07-2017, 02:55 PM
Been retard since 2002.