Hi Mynda Treacy
one of your video, you have teach about the formula of a particular day of the month, =IF(MOD(DAY(G2),30)=0,DAY(G2),"") this is a formula show a particular number of the month, from whole dates, now question is that if i want use only last number of the month, such as Jan last number is 31, while Feb have 28 last day of the month, please guide me about the formula which show end number of the month
regards
salim
Hi Sir Anders Sehlstedt
Thanks for your reply, actually i want a formula which show last date of month in number format, such as 28, 30 and 31, i hope you will easily understand from the sheet of attachment, column C and D guide you what i want. this formula will make easy financial calculation of income of the month. for example income multiply by number of total days of month.
Hi Salim
Just use =DAY(EOMONTH(G2,0))
