Date formula

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
934
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.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

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
934
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
934
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.
 

Forum statistics

Threads
1,140,911
Messages
5,703,118
Members
421,276
Latest member
davidfrommke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top