View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default Easy eay to copy / paste a formula in column

I have a formula that subtracts an individuals birthdate from the current
date (V1).

=YEAR(V1)-YEAR(U53)

Is there any easy way to copy and paste this in each cell of a column
without the current date (V1) incrementing?

If I drag the corner of the cell it increments, if I copy and paste it
increments?

i.e., =YEAR(V1)-YEAR(U53) ; =YEAR(V2)-YEAR(U54) ; =YEAR(V3)-YEAR(U55)
and so on and so on.

Thanks,
Mike