Hello All,
See attached.
Column AV has a formula that is supposed to return the MAX date in columns K:AS. However, it's ignoring dates! Columns AS and AE are ignored for example.
Please help.
thanks
Hello All,
See attached.
Column AV has a formula that is supposed to return the MAX date in columns K:AS. However, it's ignoring dates! Columns AS and AE are ignored for example.
Please help.
thanks
Why do you think that columns AS and AE are being ignored?
If you change AS3, for example, to any date after 7/25/2028, which is the current max, AV3 will show that date.
Maybe 2028 in column S was a typo that was supposed to be 2018 and this is causing the confusion.
Oh my god . . . please tell me i didn't miss that . . checking again
Last edited by AliGW; 08-06-2018 at 09:51 AM.
We can't ... you did!!!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Unbelievable. . . . Un freaking believable.
Well . . I guess it always helps to have an additional set of eyes sometimes. One of the bad things in regard to working from home.
THANKs!
We've all been there and done that - proofreading your own work is often flawed, as you tend to see what you think you've written.
Happy to help. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks