Problems with showing the correct number of days in a month?! HELP!!!!

[bftznk]

Sometimes there are 28/29/30/31 days in a month in a year, right?! What's the simplest ways to meet the following task?

1. The Year or/and month can be change
2. Once the date is change the Week of days in different(Mon, Tue...) would also be changed correctly
3. Show correctly if there are 28/29/30/31,

Do I need to use VB,Marco or
someting else?! Plz Help!

 

[bftznk]

Oh, I have also got that on another sheet on excel not sure if this help you guys to understand what I need to do :]

 

[Aladin Akyurek]

Try...

=DAY(EOMONTH(DATE(C4,F4,1),0))

=IF(COUNT(C4,F4)=2,DAY(EOMONTH(DATE(C4,F4,1),0)),"")

 

[bftznk]

For the first formulas it appears as "#NUM!#" and for the second one is blank, not sure if because I'm using excel 2007?!

 

[Aladin Akyurek]

For the first formulas it appears as "#NUM!#" and for the second one is blank, not sure if because I'm using excel 2007?!

You need to have a year in C4 and a month number in F4.

 

[miss_ell]

Hello,

With the year (2013) in A1 and the month (2) in B1, use the following formulas:

A3 =DATE(A1,B1,1)
B3, copied all the way to AE3:
=IF(ISERROR(IF(A3+1 > EOMONTH(A3,0),"",A3+1)),"",IF(A3+1 > EOMONTH(A3,0),"",A3+1))

 

[bftznk]

you need to have a year in c4 and a month number in f4.

thx, but thats not exactly what i want

1. When the month valuse changes(1-12 month) ( e.g. Feb 2013 the last day is 28th), then 29/30/31 on turn blank as well as the also the days of week (mon tue...) turn blank automatically

2. March 2013 last day 31st then 29/30/31 appear

do i need to use if function, is there such a formulas to do that ?!
Very difficult... My head is hurting -_-

 

[bftznk]

Hello,

With the year (2013) in A1 and the month (2) in B1, use the following formulas:

A3 =DATE(A1,B1,1)
B3, copied all the way to AE3:
=IF(ISERROR(IF(A3+1 > EOMONTH(A3,0),"",A3+1)),"",IF(A3+1 > EOMONTH(A3,0),"",A3+1))

It doesn't work

 

[miss_ell]

Hello,

What exactly does not work? Do you get any error messages?

 

[bftznk]

Hello,

What exactly does not work? Do you get any error messages?

it show the wrong days of week