"jer" <jearl45@xxxxxxxxxxx> wrote in message
news:3A81682A-A281-4584-A506-9AAA0370BF56@xxxxxxxxxxxxxxxx > 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
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: 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)
