|
|
 |
| found 1266 articles for 0.132 sec |
  |
Group: microsoft.public.excel.worksheet.functions · Group Profile · Search for year: 2009,month: february in microsoft.public.excel.worksheet.functions
Author: Ron Rosenfeld
Date: May 8, 2008 18:28
... 08 NOV 2008 after Three or six months later what date going to be. How can I create a function in MS Excel... certain circumstances. For example, given you want an interval of 3 months with A1: November 30, 2008 Mike H...installed or if you have XL2007). If not, then: =MIN(DATE(YEAR(A1),MONTH(A1)+{4,3},DAY(A1)*{0,1})) Both of those will give a result of February 28, 2009 --ron
|
| Show full article (0.93Kb) · Show article thread |
Group: microsoft.public.excel.worksheet.functions · Group Profile · Search for year: 2009,month: february in microsoft.public.excel.worksheet.functions
Author: Ron Rosenfeld
Date: Dec 1, 2007 23:43
... in order to find the first such-and-such day in a month); however, I notice that your original formula and your formula modified as... they report February 3, 2009 instead of January 5, 2009 as the first Tuesday of the next month (...A1,A1-DAY( A1)+8-WEEKDAY(A1-DAY(A1)-2),DATE(YEAR(A1),MONTH( A1+1),8)-WEEKDAY(DATE(YEAR(A1),MONTH(A1+1),6))) Oh, and I interpreted the OP's request for ...
|
| Show full article (1.89Kb) · Show article thread |
|
|
|
1 ·
2 ·
3 ·
4 ·
5 ·
6 ·
7 ·
8 ·
9 ·
next |
|
|
