On Apr 28, 10:30 am, bshuemaker
wrote:
Spiky,

This worked great.
One last thing. How do I input this to aply to the whole column vice typing
this into each cell. I just want the end user to type the person name,
department and report date, and have the rest of the date to fill in
automatically.
Just reminder that you have to have the Analysis ToolPak Add-Ins installed
so this can work.
Thank you for your help.


Just copy the formulas down the whole column. I mean, as far down as
you want it to go. Make sure there aren't any dollar signs in the
formula references.