Yadda ake lissafin ranar ƙarshe na wata a cikin Excel

Don samun ranar ƙarshe na wata a cikin Excel, yi amfani da aikin EOMONTH (Karshen Watan). A cikin version - EOMONTH (karshen wata).

1. Misali, bari mu yi ƙoƙari mu sami kwanan watan ranar ƙarshe na wannan wata.

   =EOMONTH(A1,0)

   =КОНМЕСЯЦА(A1;0)

Note: aiki EOMONTH (EOMONTH) yana mayar da lambar serial na kwanan wata. Aiwatar da tsarin kwanan wata don nuni daidai.

2. Yanzu bari mu yi ƙoƙari mu ƙididdige kwanan watan ranar ƙarshe na wata mai zuwa.

   =EOMONTH(A1,1)

   =КОНМЕСЯЦА(A1;1)

   

3. Har ma muna iya ƙididdige ranar ƙarshe na wata da ta kasance watanni 8 da suka gabata ta amfani da dabarar da ke ƙasa:

   =EOMONTH(A1,-8)

   =КОНМЕСЯЦА(A1;-8)

   

lura: Lissafi suna tafiya wani abu kamar haka: = 6 - 8 = -2 ko -2 + 12 = 10, watau ya kasance Oktoba 2011.