Results 1 to 12 of 12

Formula for IF it's the 2nd or 4th thursday of the month

Threaded View

jmcole Formula for IF it's the 2nd... 07-28-2016, 11:27 AM
JohnTopley Re: Formula for IF it's the... 07-28-2016, 12:14 PM
jmcole Re: Formula for IF it's the... 07-28-2016, 12:38 PM
Jonmo1 Re: Formula for IF it's the... 07-28-2016, 12:50 PM
jmcole Re: Formula for IF it's the... 07-28-2016, 02:05 PM
JohnTopley Re: Formula for IF it's the... 07-28-2016, 02:19 PM
jmcole Re: Formula for IF it's the... 07-28-2016, 02:25 PM
Jonmo1 Re: Formula for IF it's the... 07-28-2016, 04:38 PM
Tony Valko Re: Formula for IF it's the... 07-28-2016, 04:53 PM
jmcole Re: Formula for IF it's the... 07-28-2016, 06:25 PM
Jonmo1 Re: Formula for IF it's the... 07-28-2016, 06:35 PM
Tony Valko Re: Formula for IF it's the... 07-28-2016, 06:53 PM
  1. 07-28-2016, 11:27 AM #1
    jmcole is offline
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    252

    Formula for IF it's the 2nd or 4th thursday of the month

    I thought the formula that Tony Valko gave me last night worked, but it didn't. It will work if you manually type in the date in J1, but I need that date to auto populate, =NOW().

    The formulas in H15 and H16 are what I need help with. I have attached what I am working on.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for IF it's the second Thursday of the month
    By jmcole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-27-2016, 08:02 PM
  2. Display all Thursday dates in month
    By badincite in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-25-2014, 08:22 PM
  3. formula for the third tuesday and the third thursday of each month
    By Wskip49 in forum Excel General
    Replies: 6
    Last Post: 09-03-2014, 02:06 PM
  4. Number of Thursday left in a month
    By Gibby13 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-23-2012, 02:54 PM
  5. how do you count the number of thursday from whole month of April 2007
    By LEX@EXCELTIP in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-13-2007, 11:21 AM
  6. [SOLVED] 2nd Thursday of the month
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2006, 12:10 AM
  7. next thursday formula?
    By Ctrl in forum Excel General
    Replies: 3
    Last Post: 02-16-2006, 03:31 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1