Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A little more help
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|