Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: Number of days to go and past days in a month

    Hi.

    I'm trying to find a formula that I can use to calculate the number of days left in the month and also the number of days current to past days in the month.
    I've seen some examples of this when searching on line but I don’t know how I would add them to my current formula that I have to change each day.


    Project Amount: [Fees_Collected]+(([Fees_Collected]/4)*26)
    Project Amount_NB: [REFERRED]+(([REFERRED]/4)*26)

    Thank you for your time and help

    TCB

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    This gives you today's "day", thus how many days have passed in this month:

    Day(Date)

    This tells you how many days in the current month:

    Day(DateSerial(Year(Date), Month(Date) + 1, 0))
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •