Thread: How can i set a formula which shows 2nd last Monday of the month?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How can i set a formula which shows 2nd last Monday of the month?
=EOMONTH(A1,0)-WEEKDAY(EOMONTH(A1,0),3)-7


"J" wrote:

One mo-
1. How can i set a formula which shows 2nd last Monday of the month?
A1 = 2009/07/10
A2 = 2009/07/20 (a formula which shows 2nd last Monday of the month)

OR

A1 = 2009/07/22
A2 = 2009/08/24 (a formula which shows 2nd last Monday of the month)
--
J
Reply With QuoteReply With Quote