Home 
Search 
Today's Posts 
#1




Find 2nd & 4th saturday for every month
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 
#2




Find 2nd & 4th saturday for every month
Look he
http://www.cpearson.com/excel/DateTimeWS.htm heading "Nth day of month and year"  Kind regards, Niek Otten Microsoft MVP  Excel "Nikhil" wrote in message ... 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 
#3




Find 2nd & 4th saturday for every month
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 
#4




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 
#5




Find 2nd & 4th saturday for every month
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 
#6




Find 2nd & 4th saturday for every month
Try this...
=IF(FLOOR(DATE(YEAR(A1),MONTH(A1),14),7)=A1,"FIRST SATURDAY",IF(FLOOR(DATE(YEAR(A1),MONTH(A1),28),7)= A1,"SECOND SATURDAY",""))  (MSExlLearner)  "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 
#7




Find 2nd & 4th saturday for every month
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 
#8




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 
#9




Find 2nd & 4th saturday for every month
On Thursday, September 17, 2009 at 2:41:01 PM UTC+5:30, 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 Thank you its worked 
#10




Tráº£i qua nhiÃªÌ€u nÄƒm hoáº¡t Ä‘á»™ng chÃºng tÃ´i Ä‘Ã£ ná»— lá»±c vÆ°á»£t qua má»i khÃ³ khÄƒn Ä‘á»ƒ dáº§n tá»«ng bÆ°á»›c thay Ä‘á»•i Ä‘Æ°á»£c phÆ°Æ¡ng thá»©c quáº£ng cÃ¡o vÃ* mua bÃ¡n truyá»n thá»‘ng cá»§a ngÆ°á»i dÃ¢n thÃ*nh phá»‘ giÃºp cho NgÆ°á»i bÃ¡n vÃ* NgÆ°á»i mua rá»… dÃ*ng thá»±c hiá»‡n cÃ¡c giao dá»‹ch mua bÃ¡n nhÃ*, Ä‘áº¥t má»™t cÃ¡ch minh báº¡ch, nhanh chÃ³ng. RÃºt kinh nghiá»‡m qua viÃªÌ£c hoaÌ£t Ä‘Ã´Ì£ng nhiÃªÌ€u nÄƒm vaÌ€ tÆ°Ì€ nhá»¯ng Ã½ kiáº¿n Ä‘Ã³ng gÃ³p cá»§a quÃ½ khÃ¡ch, trong thá»i gian tá»›i chÃºng tÃ´i sáº½ ná»— lá»±c hÆ¡n nÆ°a nháº±m phÃ¡t triá»ƒn Website cÃ³ thÃªm nhá»¯ng tÃ*nh nÄƒng Æ°u viá»‡t, quáº£ng bÃ¡ rá»™ng kháº¯p hÆ¡n ná»¯a giÃºp cho cÃ¡c giao dá»‹ch Ä‘Æ°á»£c tiáº¿n hÃ*nh má»™t cÃ¡ch nhanh chÃ³ng. Ra Ä‘á»i xuáº¥t phÃ¡t tá»« tráº£i nghiá»‡m thá»±c táº¿ cá»§a chÃ*nh ngÆ°á»i sÃ¡ng láº*p ra CÃ´ng ty vá»›i mong muá»‘n giÃºp cho cá»™ng Ä‘á»“ng cÃ³ Ä‘Æ°á»£c thÃ´ng tin minh báº¡ch mang láº¡i giÃ¡ trá»‹ lá»£i Ã*ch tá»‘t nháº¥t cho khÃ¡ch hÃ*ng. ÄÃ¢y chÃ*nh lÃ* cÆ¡ sá»Ÿ ná»n táº£ng Ä‘á»ƒ cÃ´ng ty xÃ¢y dá»±ng phÆ°Æ¡ng chÃ¢m kinh doanh vá»›i mong muá»‘n mang Ä‘áº¿n sá»± chuyÃªn nghiá»‡p, uy tÃ*n, niá»m tin cho khÃ¡ch hÃ*ng. CÃ¡c dá»‹ch vá»¥ chÃ*nh:  ÄÄƒng tin quáº£ng cÃ¡o mua bÃ¡n nhÃ* Ä‘áº¥t  ÄÄƒng banner quáº£ng cÃ¡o  ÄÄƒng bÃ*i PR quáº£ng bÃ¡ sáº£n pháº©m, dá»‹ch vá»¥ báº¥t Ä‘á»™ng sáº£n  TÆ° váº¥n, mua bÃ¡n báº¥t Ä‘á»™ng sáº£n  MÃ´i giá»›i báº¥t Ä‘á»™ng sáº£n  ban nha quáº£ng ninh  mua dat háº¡ long  ban dat quang ninh  ban dat ha long Má»i thÃ´ng tin Ä‘Ã³ng gÃ³p, quÃ½ khÃ¡ch vui lÃ²ng liÃªn há»‡ 
Reply 

Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Second Saturday Of The Month  Excel Worksheet Functions  
Find Last Saturday of the Year  Excel Discussion (Misc queries)  
Help finding the date of the last Saturday of a given month  Excel Worksheet Functions  
Find the date of the coming up Saturday given the current date.  Excel Worksheet Functions  
first saturday in a month  Excel Worksheet Functions 