Date formula

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
933
I have dates enterd in cells in the format of SUN dd/mm/yy is there a formula for me to enter in other in the next cell that will automatically put in the next day in the same format.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
If your formula is in A1 then in B1 enter

=A1 + 1

Then click in A1 and select the Format Painter (the paintbrush on the toolbar), click in B1 and you shoulde be sorted.
 

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
933
That wont work as I have the day in the cell as well ie in cell A1 i have
SUN 23/09/06 then in next cel I want MON 24/09/06.
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985

ADVERTISEMENT

By the way, the 23rd day of September, 2006 is a Saturday.

Looks like you have Text in A1, that will happen when you put the text in front of the date in the same cell.
If you only have the true date in A1, formated as you listed, then VoG II's formula will work.
 

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
933
It isnt yet but I have tried custom formatting it to various ddd dd/mm/yy combinations but nothing is working.
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985

ADVERTISEMENT

Type 23/9 in cell A1 and hit enter. Excel will recognize it as a date and format it to the default date format setup on your machine.
Select A1 again, hit Ctrl-1.
Custom format as "ddd mm/dd/yyyy", without quotes.

Now use VoG II's formula.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Again - what is the format in A1, and have you tried the format painter?
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
People from the UK can be irritating but you are being difficult ! What is the formatting in A1 - not a difficult question.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,057
Messages
5,545,755
Members
410,704
Latest member
Cobber2008
Top