I need a formula which will return the number of days in the given month i.e January = 31, April = 30. Can this be achieved with reference to" Today()". The following conditional format formula, which I currently use, assumes that there are always 31 days in every month which obviously produces inaccurate results for many months of the year:

=IF(M4TODAY(),0,IF(N4=0,IF(((TODAY()-B4)<31),(TODAY()-B4)*(G4*0.0328767%),(G4*0.0328767%)*31),0))

I would like to replace "31" in the above with a formula that returns the correct number of days for the given month.