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,