I have a list of dates in short date format (mm dd yyyy) I need a formula that will count the number of dates that are for the previous Month and for current month.
I thought I needed to use =Eomonth(now()). Threre appears so many ways to calculate dates. What is the most efficient way to count previous and current dates
Assuming all dates are in column A, use the below formulas to count.
Count all dates of current month
Count all dates of previous month
Please Login or Register to view this content.
Count of both displayed in one cellPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by playaller; 04-25-2014 at 12:35 AM.
I suppose playaller has given the exact solution needed...
Sarang
Playller,
Thank you for your help it worked perfectly,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks