finding odd due dates

  • Thread starter jln via OfficeKB.com
  • Start date
J

jln via OfficeKB.com

OK what i have is in column E is the real due date and what i need to do is
if the date is not 9/1/2006 then i need to move the date to column E on the
same line and change the date to the next month 1st day. I need to do this
as a macro that doesnt have a set number of rows as they change each month.
 
J

JLGWhiz

I have read the posting several times and still cannot clearly understand
what it is you are trying to do. Maybe you could re-post with a more clear
description of what you want to do. If you read your posting carefully, you
will see that the references to the dates indicate that everything is in
column E, but where in column E? and is it the due date of 9/1/26 that is
the real due date? Which date do you need to move to column E, since all the
dates are in column E?
 
J

jln via OfficeKB.com

All dates are in column E but the data that i get has
9/1/2006
9/10/2006 odd due date this would be moved to column F.
and the due date in column E would be changed to 10/1/2006. I think this will
clear it up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top