+ Reply to Thread
Results 1 to 3 of 3

VBA to find the nth Day of the year

Hybrid View

meabrams VBA to find the nth Day of... 01-10-2018, 01:14 AM
nilem Re: VBA to find the nth Day... 01-10-2018, 01:26 AM
meabrams Re: VBA to find the nth Day... 01-10-2018, 01:31 AM
  1. #1
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    VBA to find the nth Day of the year

    Im looking for VBA way of calculating what day of the year is entered in a textbox this is going to be used to calculate the offset for the data on a userform to be placed in a specific column in the worksheet

    Thank you for your help
    Bramz

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: VBA to find the nth Day of the year

    something like this
    Dim i&
    i = DatePart("y", #2/5/2018#, vbUseSystemDayOfWeek, vbUseSystem)
    MsgBox i '36

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: VBA to find the nth Day of the year

    Exactly what I needed

    Thank You

+ 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. [SOLVED] Find out the year
    By meus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-08-2016, 02:39 PM
  2. [SOLVED] countifs to find the total count between this year and last year for series of data
    By maher2014 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2016, 02:39 AM
  3. find who less than one year
    By zEr. in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2016, 05:24 PM
  4. [SOLVED] To find out the first day of a financial year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2013, 11:58 AM
  5. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  6. [SOLVED] Find First, Max, Min, Last value of a month of an year
    By TK2013 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-26-2013, 07:19 PM
  7. Replies: 4
    Last Post: 07-16-2012, 07:02 AM

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