Hi All,

I have in cell A1 a date [i.e. 06/02/2012] in B1, i would like a forumla that looks at A1 and then returns the number of days in that month.

so my answer in this case would be 29, as there were 29 days in Feb 2012.

Any help would be appreciated..

Many Thanks
PW.