View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Zsolt Szabó Zsolt Szabó is offline
external usenet poster
 
Posts: 29
Default 3rd Friday every month

Calculation = Automatic Thanks. I like to ask you please to think over one
more time the problem. A1 = today's date 01/14/2007 . I like to see the
result in C3 = the next 3rd Friday of the month (it can be the same month
like today). In C4 if A1 = 01/14/2007 I like to see the 3rd Friday of the
next month, in C5 the following moth 3rd Friday. If its not to much problem I
like to ask a formula what I copy from C4 and only paste into the rest of the
column.
--
Many thanks for your help in advance. Have a wonderful day!
Zsolt


"Gord Dibben" wrote:

Assuming real dates, different months in C4 and etc.

Perhaps your calculation mode is set to "manual"

ToolsOptionsCalculation


Gord Dibben MS Excel MVP

On Sun, 14 Jan 2007 10:02:00 -0800, Zsolt Szabó
wrote:

This formula its working in C3 but not in C4, C5, C6 etc. In C4 or higher it
brings the same reults 1/19/2007