Microsoft Excel Help

[eco21]

Hi,

I want to try and covert dates 1/12/08 for example into a numerical form, so I can manipulate then,

Work out number of days between points, exclude counting certainf bank holidays etc,

I had a look at datevalue but cant seem to get it to work

Thanks

eco21

[Immatoity]

If you subtract one date from another, the answer is in days - so do the subtraction and then divide by 365 (or 365.25 http://www.punterslounge.com/forum/images/smilies/unsure.gif How you work the leap years will depend on what you're using it for and how accurate you need it)

If your answer is in date format, then just change the format to number.

http://support.microsoft.com/kb/180158 for how excel stores dates.. ( they are all numbers NOT dates)