Thread: conditional formatte date in a1 calculate the date in A2
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jcurran1ma jcurran1ma is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote