Thread: Protecting and Auto fill Columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
  
Posts: 221
Default Protecting and Auto fill Columns
Hi B

You don't need to sum it

F2 = Your inputDate
G2 = A1+180
H2 = A1+365

Format each as Date (yourFormatingPreference)

Then copy G2 & H2 down the Columns.

HTH
Mark.


Reply With QuoteReply With Quote