Help needed: How can I insert regular interval dates in excel row

		Microsoft Office Forums > Microsoft Excel > Excel
Help needed: How can I insert regular interval dates in excel row

FAQ

Mark Forums Read

Thread Tools

Display Modes

11-21-2014, 09:17 AM

Pecoflyer

Windows 7 64bit Help needed: How can I insert regular interval dates in excel row

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Hi
enter the date of the first monday in A3. Supposing you want to stay in row 3, in B3 enter =a3+7 and drag right as far as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel is changing dates.	laqa	Excel	5	11-06-2014 07:26 PM
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question	rsrasc	Word VBA	7	03-28-2014 12:28 PM
Grouping Dates in Excel Pivot Table	mskennedy	Excel	2	02-27-2013 11:09 AM
Excel 2010 - Converting fractions into dates	judicial85	Excel	5	12-31-2011 07:59 AM
MS Excel 2004 for Mac - copying dates between documents	BCRenton	Excel	4	11-10-2009 07:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:47 AM.