+ Reply to Thread
Results 1 to 5 of 5

Days until Payday

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Days until Payday

    Hey guys,

    I have a rota system sheet. I have a had a lot of help from the guys on this site with it and was hoping i could get some more. I want a header in the top right of the Shifts worksheet that says how many days until payday. I have formatted the sheet to highlight todays row, but would like the header in the top right to show how many days until the NEXT PAYDAY ONLY.

    Anyone have any ideas? Im stumped

    Thanks guys,

    Anthony
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-13-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Days until Payday

    So basically you want a countdown from todays date until the nearest date with payday in it? or am I missing what ur asking?

  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    maryport
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Days until Payday

    exactly

  4. #4
    Registered User
    Join Date
    08-13-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Days until Payday

    Im not good with it but maybe look into Vlookup and something with to do with matching the nearest payday/and corresponding date - TODAY ()
    then add a check to make sure that the date hasn't passed and if so to move on to the next one. Sorry I can help you with it more

  5. #5
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Days until Payday

    Try the DATEDIF function where B5 is the start date and B18 is the end date. This will count the number of days between the dates.

    Please Login or Register  to view this content.
    Jim O

+ 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] A number of days into weeks and days-How do you convert the decimal part of 0.571429
    By Robert Christie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2020, 09:37 PM
  2. Convert days -> Years, Months, Days, Hours, Minutes, Seconds
    By brharrii in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2012, 06:44 PM
  3. APR on Payday Loans
    By midds in forum Excel General
    Replies: 3
    Last Post: 06-14-2011, 04:23 AM
  4. Payday formula
    By Prospero in forum Excel General
    Replies: 4
    Last Post: 02-27-2005, 07:34 PM
  5. can anyone help me with a payday calculator?
    By cube in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2005, 12:06 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