One way, put the holidays in a column. Name it, say, "holidays". Assume
A1 contains your end date. Then
=A1-TODAY()-SUMPRODUCT(--(holidays=TODAY()),--(holidays<=A1))
In article ,
"Jan Buckley" wrote:
How can I use this same formula, or another one if available, to calculate
the days, and exclude the holidays. I tried to use workdays, but that
excludes the weekends also. Thanks.
|