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: 82
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, 8 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, 8 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: 82
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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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



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:55 AM.


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