Hi Disco;

Use this;

ActiveCell = Date - 3


Thanks,

Greg
-----Original Message-----
Hey guys,

Have searched the forum and cant find the answer to this
one!

I am trying to enter in a date in a cell using a macro;
the date needs to be
3 working days before todays date. I thought i could
utilise the NETWORKDAYS
function, but cant seem to do it.

Thanks in advance

Dan
.