conditional formatte date in a1 calculate the date in A2

J

jcurran1ma

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
 
O

OssieMac

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Conditional Formatting - Given dates within certain range of days 4
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Calculate date so many days before/after current date. 4
Calculate elapsed time excluding specific timeframe 10
IF AND Function Date Range Issues 6
Show value from one cell in another cell if today falls between a date range 5

Top