By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Excel Week-Ending date Keeps Changing

P: 105
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...

Expand|Select|Wrap|Line Numbers
  1. =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!!!!
Feb 18 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.