B
Brian
I am trying to find the second-to-last workday of every month for 2010.
So far, I have
=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))
but just returns the last workday. I have tried to modify to find the second
to last workday. Any ideas?
Thanks!
So far, I have
=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))
but just returns the last workday. I have tried to modify to find the second
to last workday. Any ideas?
Thanks!