# how to find the last date of the month in excel

#### m9vukyem

##### New 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

#### Hany ali

##### Active Member
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)``

#### GraH - Guido

##### Well-Known Member
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.