how to get number of days in a month in straight table

[Anonymous]

Hi in Straight table i have Month Dimension. I would like to calculate Sales per day. So i need number of days in each month. How to get that. please see below screen shot. For example for Jan i need to get number of days as 31. For Feb i need to get 28.. so on..

[swuehl · Accepted solution]

=day(monthend(makedate(2015, MonthField) ) )

[Anonymous]

Awesome Thank you Swuehl... Is there any cheat sheet which will help me to calculate anything based on Dates.

[swuehl]

Maybe the Help file page for date and time QV functions?

[Anonymous]

ok Will do . thanks for your help