Is there a way of getting the Last Day of any Month with the Year Ex: Mmm-YY?
I want to use
a Date-Range in a SumProduct Formula by putting the Start-Date and the End-Date for any Month but how do i get the last date
for any Month..
Though its simple, I want to keep it Dynamic so that each Month it changes and the date does not
need to be changed
I need to check the payments received in a span of three months.
i.e Present Month - 2, Present Month - 1 , Present Month
So the Column Headings are made using the Date Function
But in my SUMPRODUCT FORMULA... I need to check the Payments falling in the Range as below:
=SUMPRODUCT(--(CRITERIA 1)*(DATE RANGE>=DATE(YEAR(TODAY()),MONTH(TODAY()),1)*(DATE
I need to get the number which is for the Max Range as Different Months and Feb of Different years has different End