I work for a financial institution and looking for a formula with IF condition.If i collect that month installment, It should reduce the no of days in a month. Ex. if it is Jan 31 days , Feb 28 days etc., like for past 8 months. Kindly help
use end of month formula
Suppose you enter 1st June 2015 as
in my computer I have to enter date as month/date/year
in some computers it is date/month/year.
for you check control panel-region and language, format and see for short date.