A little more help

[cummingse]

I ask for help on a date formula and got answer that does what I wanted it to.
This is it:

A1: start date
B1: =IF(MONTH(A1+1)=MONTH(A1),A1+1,"")
C1: =IF(MONTH(A1+2)=MONTH(A1),A1+2,"")
and so on.
The only problem is that when cell A1: start date is empty cell B1 shows 1 and cell C1 shows 2.

I would like these Cells to be blank if cell A1 is blank and if there is a date in cell A1 then fill in the cells B1 and C1.
Thanks for any and all help.

[Earl Kiosterud]

Cummings,

=IF(ISBLANK(A2),"",IF(MONTH(A2+1)=MONTH(A2),A2+1,""))
=IF(ISBLANK(A2),"",IF(MONTH(A2+1)=MONTH(A2),A2+2,""))

It helps if you use a subject line that's more descriptive. Perhaps
"Checking end of month date"
--
Earl Kiosterud
www.smokeylake.com

"cummingse" <[email protected]> wrote
in message news:[email protected]...
>
> I ask for help on a date formula and got answer that does what I wanted
> it to.
> This is it:
>
> A1: start date
> B1: =IF(MONTH(A1+1)=MONTH(A1),A1+1,"")
> C1: =IF(MONTH(A1+2)=MONTH(A1),A1+2,"")
> and so on.
> The only problem is that when cell A1: start date is empty cell B1
> shows 1 and cell C1 shows 2.
>
> I would like these Cells to be blank if cell A1 is blank and if there
> is a date in cell A1 then fill in the cells B1 and C1.
> Thanks for any and all help.
>
>
> --
> cummingse
> ------------------------------------------------------------------------
> cummingse's Profile:
> http://www.excelforum.com/member.php...o&userid=25611
> View this thread: http://www.excelforum.com/showthread...hreadid=394421
>

[Roy Wagner]

Give this a shot

B1=: =IF(A1="","",IF(MONTH(A1+1)=MONTH(A1),A1+1,""))
C1=: =IF(A1="","",IF(MONTH(A1+2)=MONTH(A1),A1+2,""))

You can click cell A1 and then select DATA/VALIDATION to make sure they
enter a date meeting your criteria and allow it to be blank as well.

Roy
--





"cummingse" wrote:

>
> I ask for help on a date formula and got answer that does what I wanted
> it to.
> This is it:
>
> A1: start date
> B1: =IF(MONTH(A1+1)=MONTH(A1),A1+1,"")
> C1: =IF(MONTH(A1+2)=MONTH(A1),A1+2,"")
> and so on.
> The only problem is that when cell A1: start date is empty cell B1
> shows 1 and cell C1 shows 2.
>
> I would like these Cells to be blank if cell A1 is blank and if there
> is a date in cell A1 then fill in the cells B1 and C1.
> Thanks for any and all help.
>
>
> --
> cummingse
> ------------------------------------------------------------------------
> cummingse's Profile: http://www.excelforum.com/member.php...o&userid=25611
> View this thread: http://www.excelforum.com/showthread...hreadid=394421
>
>