absquatulation
New Member
- Joined
- Nov 11, 2005
- Messages
- 49
Hi Guys,
OK, so I can calculate the number of days to the end of the month
=(DATE(YEAR(ref),MONTH(ref)+1,0)-(ref1+(DATE(YEAR(ref),MONTH(ref),0))))
but, how do I calculate the number of "working days" to the end of the month??
any ideas, 'cos it's floored me.
Thanks,
Simon
OK, so I can calculate the number of days to the end of the month
=(DATE(YEAR(ref),MONTH(ref)+1,0)-(ref1+(DATE(YEAR(ref),MONTH(ref),0))))
but, how do I calculate the number of "working days" to the end of the month??
any ideas, 'cos it's floored me.
Thanks,
Simon