Automatic update of a simple date row in a workbook template

I have an apparently quite simple problem, but i find it quite challenging when it comes to organize cells filling multiple cells with the date only the day the change has been made, without updating each day. So in example:
Cells B2:B16 need to contain today's date: 19.4.2012., and the most important reason is that it is meant for a daily report template for work, so from the moment i write 19.4.2012 in B2, the cells automatically obtain the date, and it does not update depending on the PC's date, ie with the =TODAY() function. So when my supervisor takes a glance at my report from 19.4.2012 after 3 days, it should stay 19.4.2012.

I did try and solved it quite "rural", by typing today's date in the first (B2) cell, and the rest just had a draged'n'dropped function =B2. This is just about my personal need for simpler yet faster responses from a template that i will use every day. As i study Software Engineering, you might understand my need for speed and...well....complicity . I could yet again spend some time learning about usage of the VB interface that runs behind, and the private sub's and stuff like that, but since I use Visual C# and eventually C++....that could take a while , combine that with everyday studying and a 6h workday after/before that...

Thanks in advance!

You can insert today's date (fixed) into a cell by CTRL-semicolon, then press Enter. Then you can copy/paste the date into subsequent cells, or as you suggest, have the formulae in place to take the data automatically from B2.

Hope this helps.

Pete

You can insert today's date (fixed) into a cell by CTRL-semicolon, then press Enter. Then you can copy/paste the date into subsequent cells, or as you suggest, have the formulae in place to take the data automatically from B2.

Hope this helps.

Pete

Thank you Pete_UK,

I see that this forum is one of high quality and fast response, makes me want to stick around . I could maybe stick the workbook itself in an attachment into this topic, so people can actually see and visualize the problem. The option with the inserted formula = B2 has it's firm grounds as being simple and user friendly. Yet i still tend to look for a solution that maybe would not require any action from the user, you followin' ? I also think that the cruel underestimate of Excel's power among people is a closed box of stereotypes, so i search for the ultimate user-friendly and "high-tech" like solution.

The optimum scenario for the template would be:
-Save it on the device you work on
-Open it on per se...20.4.2012
-Work (enter people, addresses, short comment's...)-date is today's date
-All dates are unchanged for good once you send your report at the end of the workday
-The next day, the template has the date 21.4.2012
-Read from top again

This does sound a bit overkill with the part dynamic-part static date change, even to me believe me . If someone could bring this whole idea to life, I would be greatly indebted just for the high standard of my question !