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