Date From: (previous month first day)
=DateSerial(Year(Now), Month(Now), "1").AddMonths(-1)
Date To :
(previous month last day)
Date To :
(previous month last day)
=DateSerial(Year(Now), Month(Now), "1").AddDays(-1)
=DateSerial(Year(Now), Month(Now), "1").AddDays(-1)
Reference:
Reference:
http://stackoverflow.com/questions/7842877/first-and-last-day-of-current-month
http://stackoverflow.com/questions/7842877/first-and-last-day-of-current-month
No comments:
Post a Comment