Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. migalley

    Add at least a month to a date.

    Hi Geoff, I followed your advice, and it works!!! I hadn't realised that Select Case would be the only way to do this. Thank you for your help. It was very useful. Regards, Gabby
  2. migalley

    Add at least a month to a date.

    Hi Geoff, The macro seems to work quite well, but I have found a problem. If I start with a date of 31 Jan 2000, and want to add a month, there is of course no 31 Feb 2000. So the program jumps from 29 Feb 2000 to 2 Mar 2000. It thinks that 2 Mar 2000 = 31 Feb 2000. Is there any way to make...
  3. migalley

    Add at least a month to a date.

    Hi Geoff, Thanks for the solution. I may need to adapt it to the Macro I already have written, so I'll let you know how it goes with an update tomorrow. Thanks once again!
  4. migalley

    Add at least a month to a date.

    Hi all, I have a set of data in Excel, which is sorted with dates. I want to search for the following month's data and compare like data for like. So I start on 5th March, and search and sort up to and including 5th April. However, if I start on 19th September, and 19th October is a weekend, I...

Part and Inventory Search

Back
Top