Hi
I would like to put the period the transaction was done in the sales master next to the transaction.
I have the normal sales master report on the first sheet and the period table on the third sheet.
Now I'm trying to put in an excel formula to look at the transaction and then determine between what dates the transaction falls and return the period.
The reason I want this is because I have created a sales master that shows the total sales per month per customer. But the months aren"t the normal January, February, March month. The first month will start on 1 January but end on 24 January and the second month will start on 25 January and end on 23 February and ect. . . So the report isn"t putting the right transactions in the right month. For example it will put an transaction that was done on 25 January in January and not in February.
If someone have a good way of creating this report or can help me with the excel formula or even maybe a sql query I will appreciate it allot.
Thanks