Calculate calendar days

[Aland2929]

I have a list of months in column A and would like a formula in column B that calculates the number of calendar days for each month (i.e. Jan=31, Feb=28 etc.)
Thanks in advance

[zbor]

That would vary for Feb from year to year.

[Fotis1991]

Hi

Try

Please Login or Register  to view this content.

[zbor]

Try this where you can just change month number (1,2,3,... ) in A2:

Please Login or Register  to view this content.

For Fotis soution you need to have whole date (like 15.4.2014)

[Fotis1991]

For Fotis soution you need to have whole date (like 15.4.2014)

OR formatting that whole date as m.

[G74S]

As long as the month & year are entered then Fotis' equation works fine (you just got in Fotis before I was going to respond) and this then also covers for leap years

[zbor]

OR formatting that whole date as m.

Of course, you can do that to show number 1,2,3... but formatting is not important. What is important is how value is entered in the cell.
That's what need to be clarified for the user.

[Aland2929]

Thanks very much to all.

[G74S]

Of course, you can do that to show number 1,2,3... but formatting is not important. What is important is how value is entered in the cell.
That's what need to be clarified for the user.

So the column heading could say 'Enter Month as MM/YY' and as long as the cell is formatted correctly then everything will work fine

[zbor]

Right.....