I hope someone can shed some light on a small dilema I have.
I am somewhat of an excel novice and am presently working my way through learning lots on Excel 07.
My task is to work out the days lapsed between two dates; not hard in itself - until some wise crack dedided that they wanted to know the days elpasped over years (irrespective of weekends/workdays etc)
The data (dd/mm/yy format):
A1 = 31/05/08 (Start date)
A2 = 20/05/09 (End date)
I have been using (numeric and general format)
Yet I am constantly returning negative figures - please could point me in the right direction?