Hi all,
=A1+1 will give the proceeding date, but can anyone tell me how I can do this with the days of the week ie: Mon, Tue, etc....
Thanks a lot
loopiloo
Hi all,
=A1+1 will give the proceeding date, but can anyone tell me how I can do this with the days of the week ie: Mon, Tue, etc....
Thanks a lot
loopiloo
Click on the cells you've used these formulas in and press CTRL-1 to open the format box, format the cells as Custom: DDD
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Also, Excel is pretty smart.
If you type "Mon" into a cell, then grab the little black handle in the lower right corner of the cell and drag to the right, Excel will fill in days of the week.
Changed format to DDD and only shows "value"
I do not want to drag the day so that excel will fill in the respective cells with the days... I want to be able to put one day in one cel - and all the other cells will be updated
Anyway, thanks so far
loopiloo
If A1 contains the day of week as Sat, Wed etc. as text not a formatted date then you can use this formula to get the next day
=TEXT(MATCH(A1,TEXT({1,2,3,4,5,6,7},"ddd"),0)+1,"ddd")
Thanks a lot....!
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks