Formating cells

Hi Claire

Thank you for your question

You can use the datedif function to do this. The function has the following arguments

=Datedif(First date,Second date,"d")

Here the "d" indicates that the difference between the dates is to be returned in days. Alternatives are "m" for months and "y" for years.

Please note that this function needs to be typed in as it is not covered in the paste function dialog

Regards

Stephen