Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2021, 10:08 AM
oscarlimerick oscarlimerick is offline Question about autofill Windows 8 Question about autofill Office 2013
Advanced Beginner
Question about autofill
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default Question about autofill

I need to be able to autofill column A cells with a date that is every Saturday for the next few years. Is this possible? And if so how is it done? Please see excel attachment. Many thanks
Attached Files
File Type: xlsx excel support autofill.xlsx (9.0 KB, 6 views)
Reply With Quote
  #2  
Old 01-14-2021, 11:30 AM
Purfleet Purfleet is offline Question about autofill Windows 10 Question about autofill Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Cant you just use +7?
Attached Files
File Type: xlsx Copy of excel support autofill_Purfleet.xlsx (24.2 KB, 6 views)
Reply With Quote
  #3  
Old 01-14-2021, 12:48 PM
oscarlimerick oscarlimerick is offline Question about autofill Windows 8 Question about autofill Office 2013
Advanced Beginner
Question about autofill
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Smile

I can, it appears my problem was using the Jan 16 2021 date format and I need to use the yyyy-mm-dd format for this to work. Thanks for the solution
Reply With Quote
  #4  
Old 01-15-2021, 04:12 AM
ArviLaanemets ArviLaanemets is offline Question about autofill Windows 8 Question about autofill Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

There are several ways ...
Attached Files
File Type: xlsx Saturdays.xlsx (13.5 KB, 5 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating AutoFill form - AutoFill information depending on a selection. RyanHarper Word 3 06-15-2015 01:01 PM
Autofill Stacybug1 Excel 2 01-28-2015 01:04 PM
Autofill Address dazwm Outlook 13 08-21-2013 09:28 AM
Advanced Autofill question Sepoy25 Word 1 03-17-2013 04:32 PM
"To:" field autofill question hcits Outlook 4 10-13-2011 12:10 PM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft