Excel Week-Ending date Keeps Changing

[jmarcrum]

Hi all,

I have an excel spreadsheet that in column A, has a formula under the first row in A2 that automatically calculates the Week-ending date when someone starts typing something in cells B2, C2, D2, E2, or F2...and so on, down through row A500.

Here's my formula...

=IF(OR(B2<>"",C2<>"",D2<>"",E2<>"",F2<>""),NOW()+7-WEEKDAY(NOW(),1),"")

However, here's my problem...

Each week, everytime I open up the worksheet...all of the week-ending dates change to THIS WEEK'S WEEK-ENDING DATE...AHH!!!!

How can I fix this???

Thanks so MUCH!!!!