hi
use formula =INT((EOMONTH(F1,0)-1)/7)*7+1
where cell f1 contains any date in that month.
Cheers!!
On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
Hi Group,
can you please let me know how can we find last sunday of the
=TEXT(MAX((TEXT((ROW(INDIRECT(A1:EOMONTH(A1,0,DDD)=sun)*(ROW(IND
IRECT(A1:EOMONTH(A1,0),DD/MM/)
With c+S+E
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Sent: Thursday, June 05, 2014 12:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
=INT((EOMONTH(A1,0)-1)/7)*7+1
Put any date of the month in question in A1 - does not matter what date.
HTH/Abhishek
On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS
excel-macros@googlegroups.com wrote:
Hi Group,
can you please let me know how can we find last