How to generate next date if not available in table

[JHB]

Is the date you get in the Excel sheet like:
Example 1:

7/2/2016 8:47 AM

Example 2:

01-09-16 5:36 PM

 

[Ashfaque]

Yes this way;

01-09-16 9:04 AM
04-09-16 7:56 AM
04-09-16 6:40 PM
05-09-16 8:11 AM
....
....

Thanks...

 

[JHB]

Then you can use the database you posted in post #13.

 

[Ashfaque]

Hi JHB,

Further to your code given a few days back, I have added my code in between to export data while creating multi sheet in Excel.

Initially sheet1 shall be filled up with employee punch-in n out data and if data continues for next employee, it shall add new sheet in Excel file and and export data that relevant to new employee. - Pls see my attached file.

I think I am close to target.

After a long try, I am stuck up. Bcz my export code is generating few date after completion of month. Means if suppose September should end up with date 30 but it is still generating 3 additional dates.

Likewize at last sheet it is not reaching to 30 Sept. It is generating till 29th Sept.

Can you please help to sort out this issue.

Thanks,

 

[JHB]

Sorry but your code is me still too messy so I have extended the code I sent to you earlier.

 

[Ashfaque]

Thanks a ton JHB.

Thats no prob. I will add my code again and let you know after final if I reach to my target.

Thanks again.