If condition formula using dates/no. of days in the moth [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
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


1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
use end of month formula
Suppose you enter 1st June 2015 as
6/1/15
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.

then in A2 type the formla
=DAY(EOMONTH(A1,0))

format A2 as number with no decimals.