Hi there,
I need help in retrieving week number of the month based on my transaction date. Below is the example of my expected results.
Invoice Trans. Date Week
IN001 03/01/2011 2
IN002 31/01/2011 6
IN003 01/02/2011 1
IN004 28/02/2011 5
IN005 06/03/2011 1
IN006 14/03/2011 3
Urgently need help in getting the right formula as I have try a lot of time but could not get the accurate output. Your help is kindly appreciated.
Thanks in advance...