Excel question

[ben1977]

I’ve just started using Excel 2010 for work and am trying to get my head around how the formulas work.
What I’m trying to do is have each cell worth credits. So when I put a date in that cell, excel will recognise that date as 2 credits and add it to subtotal.

Example

................................D.................................................................................credits


3........................ 17/09/11.............................................................................. 2




edit

i had to put dots in cos the text didnt like my example