Forum Discussion
Martin Taylor
Oct 24, 2017Copper Contributor
help needed on waiting list spreadsheet
I am using a range of data to display age at a certain date. The formula i am using is: =DATEDIF(C3,R2,"m")/12 where C3 is a date of brith and R2 is the current date. My problem is that when I copy...
SergeiBaklan
Oct 24, 2017Diamond Contributor
Hi Martin,
Use absolute reference
$R$2 instead of R2
Martin Taylor
Oct 24, 2017Copper Contributor
Thanks
Worked like a charm
Worked like a charm