dates macro vba

Hello, I constantly work with product inventory and I would like to know how to split dates based on time periods (Calendar Years or Time Periods i.e. 4/1/16 - 3/31/17 or 10/1/16 - 9/30/17. Is there a formula I can use for this... For Example I have the following product with time period...

hi every one i have file which has data of last 30 days but it have to extract data daily of last 15 days from current day. now i am manually putting the dates of last 15 days and using vlook up to match but i guess there is another way through VBA . the data is in column A. Any one please...

Hi Gurus, I want to find the cells with dates using vba macro. I'm hoping to find dates under column Q which contains dates formatted as "m/d/yyyy hh:mm" and a text "---". After that, the return value is in column B which I plan to use offset function. I just also want to add that I'm a...

I am looking for help re: macro code for the following: - I have numerous rows of data, each with a start date (column G) and end date (column H) - I am trying to write a macro that will populate all dates between, including start date, across each row, beginning at column L and populating to...

I have a table ("Open Orders") with a column ("Date Paid"). If there is a date in the Date Paid column then I have a macro that removes that record from the table. What I want to do is use code that determines if any of the dates that have been entered are not equal to today's date. If they are...

Hi, Not sure if this is even possible but maybe it is and Im just not creative enough to create. I would like to be able to find dates in column C dates and replace the cell with text representing the month. For instance if cell C9 has 1/1/13, the macro would replace the data in there with...