Number of days left in a month

[CodyMonster]

I have a problem, hopefully someone can answer. This board has never let me down in the past.

I'm trying to calculate the amount of volume of a product in a month, however, the volume might be delivered over two months.
Example:

• I have 1000 gallons being delivered from Jan 28th to Feb 4th
• Not taking into account weekends or holidays, I have 3 days in Jan and 3 days in Feb
• this would equal 166.66 gals per day.
• this means I would have 500 gal in Jan and 500 in Feb
• the gallons and dates change and are not static

I already have the working days and the holiday calendar working per
https://msdn.microsoft.com/en-us/library/dd327646(v=office.12).aspx

Anyone have any ideas?
I was thinking of trying to work out what the last day of the month is, and use the above function with the end date as the last day of the month for Jan. And the Beg of the month for the Feb. But I need to find a way to get Feb 1, 2015 if I have the month of Feb. And I need to find a way to get Jan 31, 2015 if I have the month of Jan.

Any help would be great..

 

[etaf]

=EOMONTH(A1,0) will look at the date in A1 and give the end of that month
=EOMONTH(A1,1) will look at the date in A1 and give the end of the next month

=EOMONTH(A1,0)+1 will give the start of the next month

 

[CodyMonster]

Is there an EOMONTH function in Access.. ?

=EOMONTH(A1,0) will look at the date in A1 and give the end of that month
=EOMONTH(A1,1) will look at the date in A1 and give the end of the next month

=EOMONTH(A1,0)+1 will give the start of the next month

 

[Joe4]

No, I think Wayne thought he was in the Excel forum.
However, it can be calculated in Access. See here: http://www.mrexcel.com/forum/microsoft-access/611849-eomonth-equivalent-access.html

 

[etaf]

opps - sorry about that

 

[CodyMonster]

Thanks guys... always a help..