date function ...
This may be very simple but the result is not what I expect, any help
suggestion would be greatly appreciated.
In cell a1 I have 10/15/2004
in cell b1 I put in the formula
=DATE(YEAR(A1)+1,MONTH(3),DAY(30))
I am expecting the result to be 03/30/2005, however the result I am getting
is 01/30/2005.
Any suggestions
--
thanks as always for the help
jer
.
Relevant Pages
- Re: Color a single digit in a mult-digit number cell
... Microsoft MVP - Excel ... A suggestion is to copy the ... > not type anything but choose something under Format (for example Font ... For example, if I type 346 in a cell, I would ...
(microsoft.public.excel.misc) - Re: dropdown list to a page in worksheet
... I followed Aladin's suggestion and added IFto check for a blank cell so ... If ranges are not named, ... I have a Page for each name in Worksheet2 ...
(microsoft.public.excel.newusers) - RE: How to modify the web link for retrieving data from external s
... If I would like to refer specific sheet, do you have any suggestion on how ... cell A1 on a sheet. ... Then Record a macro to do what you want to do. ...
(microsoft.public.excel.misc) - Re: Question about multiple IFs
... Thanks for the suggestion, I am sorry I don't understand it. ... "Don Guillett" wrote: ... "Roger Govier" wrote: ... Did you try what I suggested, copying my formula to Cell B2 on Sheet2 ...
(microsoft.public.excel) - Re: Grow a range by # of lines by right click on grow tool & type
... If we're talking about *filling*, there's a dialog box that can help you *fill* easily and quickly, if you're looking to go down a 1,000 rows or across a couple hundred columns, and accomplish this without having to "drag" the cells. ... When I try what you suggested, I just get the value in the cell repeated, ... > Jaleel's suggestion, it gets me there. ... >> This post is a suggestion for Microsoft, ...
(microsoft.public.excel.misc) |
|
