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...
Expand|Select|Wrap|Line Numbers
- =IF(OR(B2<>"",C2<>"",D2<>"",E2<>"",F2<>""),NOW()+7-WEEKDAY(NOW(),1),"")
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!!!!