hi everybody,
Glad to see after a long time.
I had a worksheet containing raw data with Transaction date & Amount column.My requirement is how would i show the billing cycle dynamically created based on the transaction date.
For example: if the transaction date is say,05/19/2007 (mm/dd/yyyy)
i need to show the billing cycle for the same transaction 21/05/07 - 20/06/07
I need to show a column containing the billing Cycle for every transaction basing on the month entered in Column B2.
Each Billing Cycle consists of 30 days starting from 21st of the current month to the 20th of the next month.And the due date is 15 days from the billing cycle.
I had attached the worksheet.
TIA
Bookmarks