Sorry, an error occurred while loading the content.

Re: ]] XL-mania [[ Ask: End of The Month

Expand Messages
• you can try  this : =DATE(YEAR(A1),1+MONTH(A1),1)-1   thank u   Edi ________________________________ From: Quality Assurance
Message 1 of 5 , Mar 8, 2011
• 0 Attachment
you can try  this :

=DATE(YEAR(A1),1+MONTH(A1),1)-1

thank u

Edi

From: Quality Assurance <quality.assurance@...>
To: XL-mania@yahoogroups.com
Sent: Wednesday, March 9, 2011 8:53:35
Subject: ]] XL-mania [[ Ask: End of The Month

Dear Moderator,

Please give me your advice for this newbie on excel.

Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"

Misal :
January itu End Of the Monthnya = 31-Jan-2011
February itu End Of the Monthnya = 28-Feb-2011

Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.

Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.

Thanks a lot for your advice

Salam

• misal suatu data DATE (tanggal berapa saja, asal bermilai 0) ada di A1 Tgl akhir bulan (data date) = DATE(Year(A1), Month(A1)+1,0) Jumlah hari (bilangan
Message 2 of 5 , Mar 8, 2011
• 0 Attachment
misal suatu data DATE (tanggal berapa saja, asal bermilai > 0)  ada di A1

Tgl akhir bulan (data date)
= DATE(Year(A1), Month(A1)+1,0)

Jumlah hari (bilangan asli) dlm bulan tsb
=DAY(DATE(Year(A1), Month(A1)+1,0))

2011/3/9 Quality Assurance <quality.assurance@...>

Dear Moderator,
Please give me your advice for this newbie on excel.
Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"
Misal :
January itu End Of the Monthnya = 31-Jan-2011
February itu End Of the Monthnya = 28-Feb-2011
Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.
Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.
Thanks a lot for your advice
Salam

• saya coba bantu ya, coba: =DATE(YEAR(A1),MONTH(A1)+1,0)
Message 3 of 5 , Mar 8, 2011
• 0 Attachment
saya coba bantu ya,

coba:
=DATE(YEAR(A1),MONTH(A1)+1,0)

>semoga bermanfaat

--- In XL-mania@yahoogroups.com, "Quality Assurance" <quality.assurance@...> wrote:
>
> Dear Moderator,
>
> Please give me your advice for this newbie on excel.
>
> Untuk mengetahui "tanggal terakhir dalam suatu bulan pakai formula apa ya?"
>
> Misal :
> January itu End Of the Monthnya = 31-Jan-2011
> February itu End Of the Monthnya = 28-Feb-2011
>
> Secara automatic muncul demikian, setelah disorot salah satu tanggal dalam 1 bulan tersebut.
>
> Kalao ada selain pakai formula =EOMONTH() yaaa, kerena perlu install ToolPak Add in lagi.
>
> Thanks a lot for your advice
>
> Salam
>
Your message has been successfully submitted and would be delivered to recipients shortly.