I need to have a cell on my spreadsheet(B3) display the first day(monday) of the current week in a dd/mm/yyyy format. I would like this to be calculated and updated when a macro button is pushed. I already have the button set up, just can't quite figure out the code. Any thoughts?
Thank you for your time.
try this
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Getting close, but I need to operate under the assumption that the user may hit the macro on different days of the week. That being said, the "...Now() + 2..." won't cut it. Is there a way to do this dynamically? However, I do not understand how much of excel works, so that may be correct. What is the Now() +2 doing?
Last edited by jclark4321; 09-18-2013 at 06:41 PM.
actually it should work on any day....I'm subtracting 2 days from the weekday function....it is dynamic by the fact that I'm substracting from the weekday function...try it tomorrow and it should still come up on 16/09/2013...at least it does on my system...I use this formula in a template that the demand analyst here run whenever they want...it loads a file that is always created on Monday of that week. If it doesn't work tomorrow let me know and we'll work on it....
Well fantastic, thank you very much! :
glad I could help....and thanks for the points...again, though, if it doesn't work, let me know....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks