Days in Month

[Frank Kabel]

Hi
try
=(A3/DAY(DATE(YEAR(A1),MONTH(A1)+1,0))*(A2-A1)

-----Original Message-----
Hi

does anyone know how to calculate the days in the current month.

What I am trying to do is is calculate a pro rata amount

eg Cell A1 Start Date, A2 End Date, A3 Amount.

Example Start 15/04/04, End 30/04/04, Amount $100.00,

what I need to do is calculate the number of days (in the
case) in April 04 divide the amount by number of days in
month, then times amount by difference(number of days)
between End and Start