LinkBack URL
About LinkBacks
Hi, Looking for the formula so if I type in a DAY of the week ( Monday) in B3 all the cells below it will auto fill with the following DAYS of the week continuosly.
Thank you
Hi, Looking for the formula so if I type in a DAY of the week ( Monday) in B3 all the cells below it will auto fill with the following DAYS of the week continuosly.
Thank you
Last edited by CKD777; 02-13-2012 at 05:36 PM. Reason: Solved
Here is one way, assuming you type day in A1:
copied down.
=INDEX({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},MOD(MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"},0),7)+1)
if you have an actual date in A1 formatted to show day of the week, then simply =A1+1 formatted as day copied down
Last edited by NBVC; 02-13-2012 at 04:45 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
.............................
Last edited by CKD777; 02-13-2012 at 05:04 PM.
Worked great, thank you!
Could you also give me the formula to do the same thing with DATES? If I fill in 2/25/12 in A3 then A4 will be 2/26/12 and on and on continously. I tried A3+1 but untill I put a date in A3 A4 shows 1/1/1900 and goes on from there.
Also on the previous DAY fomula, is there a way to keep the #N/A from showing up. It populates all the cells below B3 until a day is inputed.
Maybe
=IF(A1="","",A1+1)
copied down and formatted as dddd
This version will give your successive days below B3....but return blanks if B3 is blank
=IF(B3="","",TEXT(MATCH(B3,TEXT({7,1,2,3,4,5,6},"dddd"),0),"dddd"))
Audere est facere
THANX - All worked great! YOU ROCK!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks