Putting the period next to the TxDate in Pastel Evolution

 

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"Tmt 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"Tmt 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