EXCEL HELP

HRD

Member
Aug 5, 2010
69
2
0
here it is
Code:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

Macho me formula eka kohomada modify karanne hariyatama auruddakin mee laga payment eka due kiyala kiyanna (Ex. Joined on 01.05.2012 payment to appear on 01.05.2013)

Greate help please......................

Macho api Excel forum ekak arimuko egenaganna asa ayata eganagannath ekka
 

ms48mail

Well-known member
  • Jan 11, 2010
    11,647
    964
    113
    කැළණි මිටියාවතේ
    Macho me formula eka kohomada modify karanne hariyatama auruddakin mee laga payment eka due kiyala kiyanna (Ex. Joined on 01.05.2012 payment to appear on 01.05.2013)

    Greate help please......................

    Macho api Excel forum ekak arimuko egenaganna asa ayata eganagannath ekka
    okama wenas karanna puluvanne

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

    ehema ewa danatamath thiyenawa. neda. ona ekak ahapan. mama danna tharamin uththara dennam welawa thiyena vidihata:yes::yes:
     
    Last edited: