How to find last day of previous month in excel without using EOMONTH
I am using apache poi to read data from excel. My excel contains date for
which I am using different formula such as Now(),Now()-7,EOMONTH() etc
POI does not have implementaion for EOMONTH so it fails to read the cell.
Is there workaround for EOMOnth in excel which i can use. I have to
basically enter first or last day or this month, prev month and 2 months
older. For this month I am using DATE(YEAR(NOW()),MONTH(NOW()),1) but not
able to write for prev month. Any help please.
Thanks, Pratik
No comments:
Post a Comment