How can i set a formula which shows 2nd last Monday of the mon
yes. it works
thx
--
J
"Jacob Skaria" wrote:
Try with date in A1
In B1
=(DATE(YEAR(A1),MONTH(A1)+1,1)-1)-WEEKDAY((DATE(YEAR(A1),MONTH(A1)+1,1)-1))-5
If this post helps click Yes
---------------
Jacob Skaria
"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
|