+ Reply to Thread
Results 1 to 5 of 5

Payday formula

  1. #1
    Registered User
    Join Date
    08-30-2004
    Posts
    8

    Question Payday formula

    Hello

    Please can somebody help me with a formula for the following...

    I would like to calculate the number of days between now and my next payday. I am paid on the 15th of the month. Where the 15th falls on a weekend I am paid on the next weekday.

    Thanks in advance!

  2. #2
    Registered User
    Join Date
    08-30-2004
    Posts
    8

    Exclamation Follow-up

    Any thoughts on this yet?

  3. #3
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    this should do it - it does not handle Monday holidays though

    =IF(Weekday(eomonth(today(),0)+15)=6,eomoonth(today(),0)+17,IF(Weekday(eomonth(today(),0)+15)=7,eomoonth(today(),0)+16,eomonth(today(),0)+15))-today()
    not a professional, just trying to assist.....

  4. #4
    Registered User
    Join Date
    08-30-2004
    Posts
    8
    Well, that's good enough for me (unless there are any other takers?)

    Cheers!

  5. #5
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    I just noticed I have several "eomoonths" ! - should all be eomonth!

+ 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