Hope someone can help. I am using excel 2010. I have over 100 rows that need to be split by month for billing purposes.
I have a begin date (a1) and end date (a2); other cells may contain name and address, amounts.
A1 01/01/14 A2 7/15/14
Is there a way to get a new row for each month?
01/01/14 01/31/14
02/01/14 02/28/14
etc.
end with 07/01/14 07/15/14
Thanks for any help.
I have a begin date (a1) and end date (a2); other cells may contain name and address, amounts.
A1 01/01/14 A2 7/15/14
Is there a way to get a new row for each month?
01/01/14 01/31/14
02/01/14 02/28/14
etc.
end with 07/01/14 07/15/14
Thanks for any help.