How do I have dates change automaticaly

gorgatron

New Member
Joined
Apr 9, 2009
Messages
2
I have a check list for work that I have to change the dates in every time I need it. Is there any way to format the cells so that when I type the first date in the rest of the dates will change? Thanks!!
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,478
There is a way!! We need a bit more info to better assist you however..
 

gorgatron

New Member
Joined
Apr 9, 2009
Messages
2
I dont know if this will help. It is in a landscape format. The page setup has the first cell blank then the next cell has the first date. next a blank cell then the next date. These go across the page until it moves down to the next row. Does this help?
 

GTO

MrExcel MVP
Joined
Dec 9, 2008
Messages
6,154
Greetings,

Landscape/page setup do not matter. Not sure if this is anywhere close to what you are asking, but if you are saying (for instance) that you want to type a date in Cell B1 and Cell D1 will update to the next day, Cell F1 the day after that and so on...

In D1 type "=B1 + 1"
In F1 type "=D1 + 1"

...and so on....

If that's way off, maybe some clarification as Jim mentioned, and/or a picture of the sheet.

Hope this helps,

Mark
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,313
Members
414,052
Latest member
Dual Showman

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