Days in a month as of today

[Guest]

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,

 

[Roger Govier]

Hi Daniel

Try
=DAY(TODAY())

 

[Bob Phillips]

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)