days of the week

  • Thread starter Thread starter K-Man
  • Start date Start date
K

K-Man

Hi,

I am looking for a way (formula) to increment days in excel, for e.g

A1
Mon
B1 should have some formula to automatically recognize the value in A1
and increment by 1 day Tue,wed, thu, fri sat or sun.

I know you can drag and excel will auto fill it however I am looking
for a formula to do this.

Thanks in advance,
 
Enter a date (like 1/7/2008) in A1 instead of "Mon"and format it Custom as
ddd. In B1: =A1+1. Copy to the right
 
Not pretty but works
=INDEX({"Sun","Mon","Tue","Wed","Thr","Fri","Sat","Sun"},1,MATCH(A1,{"Sun","Mon","Tue","Wed","Thr","Fri","Sat"},0)+1)
Note the extra "Sun" in the first array
best wishes from Nova Scotia
 
Not pretty but works
=INDEX({"Sun","Mon","Tue","Wed","Thr","Fri","Sat","Sun"},1,MATCH(A1,{"Sun","Mon","Tue","Wed","Thr","Fri","Sat"},0)+1)
Note the extra "Sun" in the first array
best wishes from Nova Scotia
Click to expand...

GR8, Thx for the help
 
Another one...

Create this defined name...
Goto Insert>Name>Define
Name: weekdays
Refers to:

="SunMonTueWedThuFriSatSun"

OK

Then enter this formula in A2 and copy down as needed:

=IF(A1="","",MID(weekdays,SEARCH(A1,weekdays)+3,3))
 
A little more compact...

=MID("SunMonTueWedThuFriSatSun",FIND(A1,"SunMonTueWedThuFriSatSun")+3,3)
 
Back
Top