Dates formula
Thanks Carlo
"Carlo" wrote:
Hi Orquidea
try this formula
=((A1-A2-WEEKDAY(A1)+WEEKDAY(A2)-7)/7*5)+WEEKDAY(A1)-WEEKDAY(A2)+5
where A1 is the later date.
hth
Carlo
"orquidea" wrote:
Hi
I want to deduct 2 dates. I also want to deduct weekend days if they are
within the period of time of the calculation. e.i
10/23/07 - 10/18/07 = 5 days minus 2 weekend days = 3 days
I want to get 3 days result.
Could someone help with this formula please.
Thanks
Orquidea
|