# split data by day

i have an list of numbers with date
i need every 15 days to be split like the sample here !

in the first row is just 1 ocurrence but later are 2 ocurrence by day
and keep grow with 2 ocurrence by day
bydate-split.xlsx
bydate-split.xlsx
Microsoft ExcelMicrosoft Office

Last Comment
Jacques Geday
Jacques Geday

did you post the same file twice ?
Like you want the output as per sheet2 ?
gowflow
Jacques Geday

An other question you say

in the first row is just 1 ocurrence but later are 2 ocurrence by day

In sheet2 you have from row 3 to 12 data in double what do you mean by 1 occurrence and 2 occurences ?

If I take as an example row 3 you have
Monday, January 02, 2012      6941            Monday, January 16, 2012      1261
Are these 2 related ? Jan 2 + 15 days = Jan 17 but you have there Jan 16

Please be more specific
gowflow
Martin Liss

This takes a long time to run. Let me know if the output is the way you want it. If it isn't I'll try to make it faster.
29016517.xlsm
Martin Liss

Do you want 15-day periods even if they span months? In other words in February (assuming it has 28 days) do you want 2/1 to 2/15 and 2/16 to 2/28 or do you want 2/1 to 2/15 and 2/16 to 3/2?

gowflow THnks !! for you fast response!!

YES !! I have the detail in here the very firts dates just have one ocurrence but later on are twice  by day

so the firts 15 days of the those firts years are 1 ocurrence

later on beging with 2 ocurrence by day !

Martin i need it bet every 15 days but  in the case of the february will be ok until 28
Martin Liss

Then try this. It's still slow.

There's a button on Sheet1 you can use.
29016517a.xlsm
Jacques Geday

So we should not span on a new month or its ok ??
gowflow
Martin Liss

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.

gowflow yes ! it have to keep going month by months through the year!!
and next year!
Martin Liss

Did you try my code????? (Click the button on Sheet1)

Martin is great wotking great but i need keep the format  colors in !

yes martin im testing ! it
Martin Liss

i need keep the format  colors in
It has the colors except for the color in B4 (and other rows) which you don't have either.

Martin !is working great ! is good to me !! Perfect !!

gowflow is like the example martin provide to helps us !

Martin is more faster !! Great Job !!

gowflow the martin solution ! is working to me
if you have any other point im open to check in !

Great Solution !!
Martin Liss

Thanks. I learned something too.
Jacques Geday

Sorry I was caught in other thing in between. Great you got what you need.
gowflow
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts

TRUSTED BY