B2: =DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

which is what you had without the square brackets

B3: =DAY(TODAY())

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Daniel Q." wrote in message
...
I need a formula that will look at today's date, figure out the days in the
month and then in a different cell give me the number of days so far in
that
month.

ie -

A1 = 1/1/07

B2 = [(DAY(DATE(YEAR(A1),MONTH(A1)+1,0))] = 31

B3 = should come up with 25 since today is Jan 25

Thx,