Find 2nd & 4th saturday for every month
Correction:
'fourth saturday
=FLOOR(DATE(YEAR(A1),MONTH(A1),28),7)
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
With date in A1
'second saturday
=FLOOR(DATE(YEAR(A1),MONTH(A1),14),7)
'fourth saturday
=FLOOR(DATE(YEAR(A1),MONTH(A1),14),7)
OR (n denotes the instance)
=FLOOR(DATE(YEAR(A1),MONTH(A1),n*7),7)
If this post helps click Yes
---------------
Jacob Skaria
"Nikhil" wrote:
I enter a date in one column, in the second column i want the day for that
date. If the day happens to be the 2nd or the 4th saturday in that month, it
should get highlighted. How do i calculate the 2nd & 4th saturdays?
Rgds
|