Find 2nd & 4th saturday for every month
Thanks that worked!!!
"Jacob Skaria" wrote:
Try the below
=IF(A1=FLOOR(DATE(YEAR(A1),MONTH(A1),14),7),"Secon d
Saturday",IF(A1=FLOOR(DATE(YEAR(A1),MONTH(A1),28), 7),"Fourth Saturday",""))
If this post helps click Yes
---------------
Jacob Skaria
"Nikhil" wrote:
Hi
Thanks for the help but let me clarify...
I have the list of dates in Col A (starting from one date and stretching for
around 3 months). In Col B, i want the cell value to be either blank or
indicate "Second Saturday" or "Fourth Saturday"
Hope this clarifies my reqt.
Thnks
Nikhil
"Jacob Skaria" wrote:
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
|