# Thread: Number of days to go and past days in a month

1. Registered User
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. Registered User
Join Date
May 2005
Location
Posts
2,888
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))

#### Posting Permissions

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