• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to find the last date of the month in excel

m9vukyem

Member
Dear sir,

how to find the last date of month given date in excel. i know the eomonth function gives the only last day of themonth but how can we check if the date is given in the excel whether the date is last day or not

ex. if an employee joined last day of month and 1st day of month his retirement date is last day of month if he joined after 1st day of month his retirement date is last day of subsequent month

help me
 
Do you expect to guess?
You must upload a file clearly explaining everything required
BECAUSE AS YOU KNOW ,if you have date in Cell A2 .TO Get the Last Day for the month from this date is
Code:
=EOMONTH(A2,0)
 
how can we check if the date is given in the excel whether the date is last day or not
ex. if an employee joined last day of month and 1st day of month his retirement date is last day of month if he joined after 1st day of month his retirement date is last day of subsequent month

Say you have a date is A2, to check if it is the last day of the month you can use this logical formula A2=EOMONTH(A2,0). True it is last day, False it is not.
 
Back
Top