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

23 10 2011

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)


Actions

Information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: