troubleshooting Question

Modify Date after Midnight

Avatar of Billa7
Billa7 asked on
Microsoft Excel
2 Comments1 Solution354 ViewsLast Modified:
Hi,

I need Experts help to add additional function in "Sub ExportSheet" macro in the attached workbook. The script was used to export Data sheet into different location and only shows/filter data with "Match" word at Column D.

Is that any possible to modify the date of the copied file (Column A) after crossing midnight (00:00) (time at column B), e.g. Cell A17 (4/2/2012) with time 01:00 (column B), since the time already crossed "00:00", therefore the date for this cell need to modified into 5/2/2012. Same goes to Cell A18 and A19. Similar date modification required for A33:A35 (5/2/2012) into 6/2/2012. I have attached the workbook together with sample data (I have highlighted the desired result at Column F at the sample data for Experts to get a better view.  Hope Experts could help.
Date.xls
Sample-Data.xls
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros