+ Reply to Thread
Results 1 to 4 of 4

Formula for the previous workday before the 15th of the month if it falls on a weekend.

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Romania
    MS-Off Ver
    Office 2016
    Posts
    28

    Formula for the previous workday before the 15th of the month if it falls on a weekend.

    I get paid on the 15th if it's a workday or on the last workday before the 15th if the 15th of the month falls on a weekend. I have a series of data on column a with the days of 15 in consecutive months.
    Is there a formula to return, for example for February the 13th of February because it falls on a Friday while the 15th is a Sunday?
    I heard of the WORKDAY function but I just can't seem to get it to work.

    A
    1 15/01/2015
    2 15/02/2015
    3 15/03/2015
    4 15/04/2015

    Thanks.
    Last edited by Chypp; 01-03-2015 at 04:01 PM. Reason: It was solved.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula for the previous workday before the 15th of the month if it falls on a weekend

    Row\Col
    A
    B
    C
    2
    Thu 15 Jan 2015
    Thu 15 Jan 2015
    B2: =WORKDAY(A2+1, -1)
    3
    Sun 15 Feb 2015
    Fri 13 Feb 2015
    4
    Sun 15 Mar 2015
    Fri 13 Mar 2015
    5
    Wed 15 Apr 2015
    Wed 15 Apr 2015
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Romania
    MS-Off Ver
    Office 2016
    Posts
    28

    Re: Formula for the previous workday before the 15th of the month if it falls on a weekend

    It Works! Thanks a lot!

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula for the previous workday before the 15th of the month if it falls on a weekend

    You're welcome.

+ 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] Include certain weekend in workday formula
    By szita2000 in forum Excel General
    Replies: 4
    Last Post: 12-16-2014, 03:02 PM
  2. Formula to adjust a weekend date to the previous Friday...
    By joencrystal in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2013, 05:25 PM
  3. [SOLVED] Trying to add a formula that changes to a color if goal is met by 15th day of month
    By mhoshue in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-27-2013, 01:07 AM
  4. Formula for IF/THEN EOM and/or 15th of Month based on Today's Date
    By pierzyna in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-12-2013, 03:09 PM
  5. [SOLVED] Workday vs Weekend
    By nelkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2013, 09:37 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