days of the week

[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,

 

[Niek Otten]

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

 

[Bernard Liengme]

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

 

[K-Man]

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

GR8, Thx for the help

 

[T. Valko]

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))

 

[Rick Rothstein]

A little more compact...

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

 

[Rick Rothstein]

Even more compact...

=TEXT((5+FIND(A1,"SunMonTueWedThuFriSatSun"))/3,"ddd")