+ Reply to Thread
Results 1 to 2 of 2

semi monthly date formula help please

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    semi monthly date formula help please

    I need help with a formula.

    I would like to plug in any date (5/25/2011 or 7/15/2011 or any date) and find the first date of the semimonthly pay period following the date I plug in.

    if I plug in 6/24/2011, the first day of the following pay period should be 7/1/2011, if I plug in 7/15, the first day of the following pay period should be 8/1/2011.

    Can anyone offer help?
    Thank you!

    (If you're up for the challenge, I'd also like to find the last day of the same pay period.)
    Last edited by tabegle; 05-26-2011 at 12:07 PM. Reason: fix title

  2. #2
    Registered User
    Join Date
    05-26-2011
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: semi monthly date formula help please

    I figured it out myself.

    =IF(DAY(F40)>15,(EOMONTH(F40,0)+1),(EOMONTH(F40,-1)+16))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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