conditional formatte date in a1 calculate the date in A2
 

Can I use conditional formatting to take a date shown in A1 and calculate the
date in cell A2 to read A1+ 30 and cell A3 to read A1+60 ETC€¦. so when I fill
in a1 all the dates show up automaticaly in other cells
Using Excel 2003

conditional formatte date in a1 calculate the date in A2
 

I am assuming that you want cells A2, A3 etc to appear blank until cell A1 is
populated.
If so then in A2 insert the following formula.
=IF(A1<0,A1+30,"")

In A3 insert the following formula.
=IF(A1<0,A1+60,"")

A2 and A3 will be blank until A1 is populated.


--
Regards,

OssieMac


"jcurran1ma" wrote:

Can I use conditional formatting to take a date shown in A1 and calculate the
date in cell A2 to read A1+ 30 and cell A3 to read A1+60 ETC€¦. so when I fill
in a1 all the dates show up automaticaly in other cells
Using Excel 2003

conditional formatte date in a1 calculate the date in A2
 

In A2: =A1+30

copy from A2 down as far as needed


"jcurran1ma" wrote:

Can I use conditional formatting to take a date shown in A1 and calculate the
date in cell A2 to read A1+ 30 and cell A3 to read A1+60 ETC€¦. so when I fill
in a1 all the dates show up automaticaly in other cells
Using Excel 2003

conditional formatte date in a1 calculate the date in A2
 

Hi,

I don't follow the reference to conditional formatting?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jcurran1ma" wrote:

Can I use conditional formatting to take a date shown in A1 and calculate the
date in cell A2 to read A1+ 30 and cell A3 to read A1+60 ETC€¦. so when I fill
in a1 all the dates show up automaticaly in other cells
Using Excel 2003