Results 1 to 5 of 5

How to calculate every 2nd Friday of the month based on a date on excel and ....

Threaded View

  1. 02-04-2021, 09:06 PM #1
    Optimuswicked
    Optimuswicked is offline
    Registered User
    Join Date
    02-04-2021
    Location
    HA
    MS-Off Ver
    2016
    Posts
    24

    Lightbulb How to calculate every 2nd Friday of the month based on a date on excel and ....

    Hi guys,

    How do you calculate the second Friday of a month based on date (call it B2) AND if that date is or has passed the second Friday of that month then it will calculate the second Friday of the following month. Big thank you!

    Example:

    If today is 02/04 then it will calculate 02/12. However, if the date is 02/012 or greater then it will show the second Friday of March which is 03/12.
    Last edited by Optimuswicked; 02-05-2021 at 01:39 PM. Reason: SOLVED
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] returning the date of next month's third Friday
    By apricope in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2019, 04:38 AM
  2. Formula to identify month that runs From Last Friday to Last Friday
    By Mr Stern 2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2019, 06:23 AM
  3. determining date of 2nd or last friday of any month
    By luv2glyd in forum Excel General
    Replies: 15
    Last Post: 06-25-2013, 07:07 AM
  4. [SOLVED] Checking if a date is the last Friday of the particular month
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2013, 04:22 AM
  5. Calculate 1st Tuesday or 3rd Friday of month
    By BRISBANEBOB in forum Excel General
    Replies: 3
    Last Post: 11-11-2009, 05:51 PM
  6. How to calculate the third friday of a month?
    By KJP in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2006, 06:45 PM
  7. date of last friday of previous month
    By tkaplan in forum Excel General
    Replies: 7
    Last Post: 11-14-2005, 02:10 PM

Tags for this Thread

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