$$Excel-Macros$$ last sunday of the month?

Hi Group, can you please let me know how can we find last sunday of the month? excel formula or macro would do. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ last sunday of the month?

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

RE: $$Excel-Macros$$ last sunday of the month?

$$ last sunday of the month? Hi Group, can you please let me know how can we find last sunday of the month? excel formula or macro would do. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https

Re: $$Excel-Macros$$ last sunday of the month?

=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