P Pete_UK Mar 26, 2008 #2 Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete
Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete
S Sandy Mann Mar 26, 2008 #3 Just to add to Pete's post, if you want to count both the dates 29 March and 5 May, append +1 to the end of the subtraction. ie: A1= 29/03/08 A2=5/05/08 =A2-A1+1 gives 38 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete
Just to add to Pete's post, if you want to count both the dates 29 March and 5 May, append +1 to the end of the subtraction. ie: A1= 29/03/08 A2=5/05/08 =A2-A1+1 gives 38 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk Just subtract the earlier from the later and format the cell as General or Number. Hope this helps. Pete
