Hi,
Hope you can help. We have sales reps that sell online advertising space that can start and finish when the customer wants. EG booking from 06/01/06 to 05/02/06 for a total of $1,000.
The accounts department needs to show the revenue in their accounting month. In this case Jan month is from 01/01/06 to 27/01/06, Feb month is 28/01/06 to 24/02/06.
So in this case some of the $1000 would be Jan revenue and some Feb revenue.
What sort of formula could I use to show what accounting month the revenue should appear in based on the start and finish date of the advertising?
i.e The sales rep can enter the contract amount and the start and finish date of the contract and the formula will work out what accounting month the revenue should appear in and show this in the appropriate month columns.
Regards
Garry
Bookmarks