Hi, I'm a newbie here so please forgive me if this has been answered a zillion times already.
Here's the problem. Imagine that over 10 years there are 60 x 2-month periods starting on the 1st day of every even month and ending on the last day of the following odd month (after which we name it).
Given a columnar list of dates that invoices were raised, how can I put (ideally in an adjacent column) which of those 60 2-month periods the invoice fell in?
For example: If an invoice was raised on 19/12/06 it belongs in the 31/01/07 billing period. If an invoice was raised on 05/07/11 it belongs in the 31/07/11 billing period.
Such a thing must be simple but I can't figure out how to do it and assume it must require a macro? I'm not a programmer - until now future and present value formulas are about as fancy as I've got. I've got a bazillion of these invoices to sort and don't want to do them all one by one if I can avoid it :-)
Thanks,
Megan
Bookmarks