What I am looking for is a way to say for example: "It's monday, this file is due to be input on Thursdays, Thursday's date is ##/##/##, therefore this is due on that date." But I don't need this just for Monday, I need it to determine the day of the week, compare it to Thursday and if it is "Less Than Thursday" to output Thursday's date.
What do you think?
=IF(WEEKDAY(TODAY())<5,"It's "&TEXT(TODAY(),"dddd")&", this file is due to be input on Thursdays, Thursday's date is "&TEXT(TODAY()+(5-WEEKDAY(TODAY())),"dd/mm/yy")&" therefore this is due on that date","")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perhaps =A1+7-WEEKDAY(A1+2). It will return the next Thursday or Thursday if it is A1
I was a little confused on what you want...here's a sample to get us started. The formula I came up with was:
=IF(WEEKDAY(A2,1)<5,WORKDAY(A2,WEEKDAY(B2,1)-WEEKDAY(A2,1)),WORKDAY(A2,WEEKDAY(B2,1)-WEEKDAY(A2,1))+7)
but I may have made it harder than it had to be
Check out the spreadsheet. You'd only need to change cell A2 if it's due on Thursday. If it's due on a different day of the week, put a date into cell B2 that is on that day of the week (the date itself doesn't matter):Test.xlsx
If this post was helpful or at least brought a smile to your face, please click the Add Reputation button as a way to say thank you!!!!!!
This is really close to what I am looking for, the only thing is it returns 6/4/2015 if the date is 6/4/2015, but I need it to return 6/11/2015 if the date is 6/4/2015. Does that make sense?Originally Posted by Pepe Le Mokko
This is really close to what I am looking for, the only thing is it returns 6/4/2015 if the date is 6/4/2015, but I need it to return 6/11/2015 if the date is 6/4/2015. Does that make sense?
attach a sample excel file with expected formatting
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Not sure exactly what you mean. Sorry I am really new to excel.
Pls attach a sample excel file with your requirment
example.xlsx
Not sure this is what you're asking for. I can vocalize what I want, but beyond that I am incapable.
Perhaps =A1+8-WEEKDAY(A1+3)
Perfect! Thank you so much for the help!
If you have the time, mind explaining why exactly that works? I understand the math I suppose, but it is beyond me how that works. I am very interested.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks