How to make Column 4 display number of day of the month ?

[paulyeo11]

Hi All

How to make column DAY display

30 when i click month= Jan.

60 when i click month= Feb.

Now i fill in 60 , it is not flexible

Paul.

[sunny_talwar · Accepted solution]

what if you use this:

=month*30

when your month = 1, the expression will give 30 and when its 2, it will give your 60 and so on..

Best,

Sunny

[sunny_talwar]

PFA the qvw

[paulyeo11]

Hi Sir

Thank you , it work fine.

Paul