+ Reply to Thread
Results 1 to 2 of 2

Change date to end of month if unless 5th April year end

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    87

    Change date to end of month if unless 5th April year end

    Hi,

    What I want:
    For this macro to pick up the date from a report in excel (Recharges), paste onto necessary sheet (individual).
    Then change all the dates to the last day of the month, except for the businesses with a 5th April year end. The expenses for april need to be split into being dated - 5th April & 30th April.

    What I have:
    Currently I have a macro that picks up everything, it just doesn't change the date to the last day of the month.

    On the individual person's ws in P2 is their year end.
    The dates will be in column "C"

    test WB below

    At this moment in time, the macro won't work until the dates have been sorted as it posts all dates at the bottom for a credit posting of drawings.
    I also have a macro (I think it is in drawings) That should be if date is blank then don't run macro.. (repeated four times) but it doesn't seem to work. Could someone explain why? Thanks

    qwerty.xlsm
    Last edited by aaaaaaiden; 02-14-2014 at 07:36 AM.

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Change date to end of month if unless 5th April year end

    If you want to calculate the last day of the month one of the easiest is to go for the 1st of the next month -1.
    Or have a table/array of values.


    click on the * Add Reputation if this was useful or entertaining.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort month/date/year data using month and date only
    By SMW820 in forum Excel General
    Replies: 8
    Last Post: 11-18-2014, 08:39 AM
  2. [SOLVED] Display the first date of the month when the month and year are selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 11:59 AM
  3. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  4. Change Date to display Month/Year
    By pdxguy_2188 in forum Excel General
    Replies: 1
    Last Post: 07-06-2011, 01:41 PM
  5. formula for prior month & year of a month end date.
    By mikeburg in forum Excel General
    Replies: 2
    Last Post: 09-25-2007, 04:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1