EXCEL HELP

[SANJEE]

යාළුවනේ මට එක්සෙල් වල දෙයක් දැනගන්න ඕනේ කාටද පුළුවන් මට මේකට උදව් කරන්න.....? දන්නේ නැති නිසා අහන්නේ හීන වෙන්නෙපා ඕකවත් දන්නේ නැද්ද කියලා.....

මේකයි සිද්ධිය..... මට තියෙනවා අපේ කොම්පැනියට හයර් ඒකට ගත්තු වාහන වලට පේමන්ට් කරන්න..... පේමන්ට් කරන්නේ හයර් එක කරපු දිනේ ඉදං දවස 30 කට පස්සේ...... ඉතින් මට එක්සෙල් වල චාර්ට් එකක් හදාගත්තාම ලේසියි මේ වැඩේට......

මට ඕනේ මම එක කොලම් එකක හයර් එක කරපු දිනය දැම්මාම වෙන කොලම් එකක පේමන්ට් එක කරන්න නියමිත දිනය වැටෙන්න........

ඒක කරන ෆෝමියුලා ඒක කවුරු හරි දන්නවානම් කියලා දෙන්ඩෝ......

දන්නේ නැත්නම් බම්ප් එකක්වත් දෙන්ඩෝ........

 

[ms48mail]

date format eken date eka thiyenna one. ehema dammoth date eka thiyena dine A1 kiyala hithuwoth
=A1+30

 

[lasa1106]

macahan " pivot table " ekak hada ganin.......ethkota lesi.......menna mekata gihin balapan

http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm

 

[oracle ckc]

View attachment 40265

 

[GAC]

date format eken date eka thiyenna one. ehema dammoth date eka thiyena dine A1 kiyala hithuwoth
=A1+30

ඔ‍ය‍ ති‍යෙ‍න්නෙ‍...

 

[eranga_rama]

date format eken date eka thiyenna one. ehema dammoth date eka thiyena dine A1 kiyala hithuwoth
=A1+30

meka tiak hari eth maseta dawas 31 k thibboth kela wenawa.

eg: 28/08/2011 ta 30 add kaloth enne 27/09/2011. eth apita enna one 28/09/2011 neda?

 

[eranga_rama]

View attachment 40265

in this one also the same problem as i mentioned earlier

 

[ms48mail]

meka tiak hari eth maseta dawas 31 k thibboth kela wenawa.

eg: 28/08/2011 ta 30 add kaloth enne 27/09/2011. eth apita enna one 28/09/2011 neda?

meya kiyala thiyenne fixed date ekak nemei machan. gaththa dine indan dina 30. enna one 27 thama ethakota. fixed date ekakata masen mase vadi wenna ganna onenam ekatath formula ekak daannam

 

[ms48mail]

in this one also the same problem as i mentioned earlier

here it is

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

 

[ms48mail]

ඔ‍ය‍ ති‍යෙ‍න්නෙ‍...

 

[SANJEE]

date format eken date eka thiyenna one. ehema dammoth date eka thiyena dine A1 kiyala hithuwoth
=A1+30

ela ela me tiyenne.......

macahan " pivot table " ekak hada ganin.......ethkota lesi.......menna mekata gihin balapan

http://spreadsheets.about.com/od/datamanagementinexcel/ss/excel_database.htm

thankz machan mama mekath check karala balannam.......

View attachment 40265

thankz machan......

ඔ‍ය‍ ති‍යෙ‍න්නෙ‍...

yeap......

 

[eranga_rama]

meya kiyala thiyenne fixed date ekak nemei machan. gaththa dine indan dina 30. enna one 27 thama ethakota. fixed date ekakata masen mase vadi wenna ganna onenam ekatath formula ekak daannam

ow uge requirement eka ekanam awulak ne.

 

[SANJEE]

meka tiak hari eth maseta dawas 31 k thibboth kela wenawa.

eg: 28/08/2011 ta 30 add kaloth enne 27/09/2011. eth apita enna one 28/09/2011 neda?

ow ekath atta.......

meya kiyala thiyenne fixed date ekak nemei machan. gaththa dine indan dina 30. enna one 27 thama ethakota. fixed date ekakata masen mase vadi wenna ganna onenam ekatath formula ekak daannam

here it is

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

e kiyanne machan me formula eka hariyatama harida...?

 

[ms48mail]

ow ekath atta.......





e kiyanne machan me formula eka hariyatama harida...?

meken karanne month eka 1 kin vadi karana ekai machan. matanam varaddak penna neh.
Ex: 30/8/2012 kiyala thibboth meken 2012/9/30 karanawa.

ara mulin dapu eke. hariyatama dina 30k ekathu karanawa. meke wenne masayak ekathu karana eka

mase anthima unoth varadi kiyala hithenawa athi neda

Ex: 30/12/2012 unoth meka auto 30/1/2013 kara gannawa

 

[SANJEE]

machan example ekak hetiyata May 31st gamu......

=A1+30 vidiyata beluwama enne June 30th.... eka harine....

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) widiyata beluwama enne July 01st..... etakota dawas 31k wenawa.....

 

[ms48mail]

machan example ekak hetiyata May 31st gamu......

=A1+30 vidiyata beluwama enne June 30th.... eka harine....

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) widiyata beluwama enne July 01st..... etakota dawas 31k wenawa.....

eka thama mama ubata kivve. mul eken hariyatama dawas 30 enawa kiyala.
ara thava kenek kivva ekata uththare thama devani para damme. masayak kiyanne dina 30kma nemeine ban. 28th wenna puluvan. 2nd eken karanne dina gaana keeya unath maasayak vadi karana eka

 

[NB Diamonds]

harine.

 

[SANJEE]

eka thama mama ubata kivve. mul eken hariyatama dawas 30 enawa kiyala.
ara thava kenek kivva ekata uththare thama devani para damme. masayak kiyanne dina 30kma nemeine ban. 28th wenna puluvan. 2nd eken karanne dina gaana keeya unath maasayak vadi karana eka

eka hari...... 1st option eka karana eka hodai ehenam.......

 

[ms48mail]

eka hari...... 1st option eka karana eka hodai ehenam.......

eth ara kalin kena kivva vage hungak than wala thiyenne fixed date ekak machan. eka kamathi vidihata daaganin.

 

[eranga_rama]

meka balapan. aruge method ekama thama. feb 28 gaththoth enne march 28.

http://www.mediafire.com/view/?p7i3hdqu43zaz7j