Libre Office/Open Office: How to check day in month

20111023

When you want to know number of day in month especially number of day in February. it is 28 or 29
if you use formula in cell like “=Day(B3)” when B3 contain 02/02/00 (02 February 2000) you will get “2″.
the February 2000 has 29 day try this formula

“=DAY(EOMONTH(B3,0))” you will get “29″

have fun with Open Office ( it also work in MS Excel)

Advertisement