Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 22nd 17, 03:37 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2017
Posts: 1
Default Need help with Excel auto fill dates

I'm trying to build a spreadsheet that will auto fill dates with an AM option and a pm option.

ideally, i would like it to show as follows

oct-22-2017-am
oct-22-2017-pm
oct-23-2017-am
oct-23-2017-pm

and so on down "a" until a set date, in this case it would be November 10th

horizontally I would have something like


[sit-ups] [push-ups] [run km] etc. The purpose would be to track 2 a day workouts for a 3 week period. any and all help would be greatly appreciated

  #2   Report Post  
Old October 24th 17, 08:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 49
Default Need help with Excel auto fill dates

ideally, i would like it to show as follows

oct-22-2017-am
oct-22-2017-pm
oct-23-2017-am
oct-23-2017-pm

and so on down "a" until a set date, in this case it would be November 10th

horizontally I would have something like

[sit-ups] [push-ups] [run km] etc. The purpose would be to track 2 a day
workouts for a 3 week period. any and all help would be greatly appreciated


Here's one way to get close.

In A2 put the starting date, for example:
10/22/2017
and use the custom format
mmm-dd-yyyy-am/pm

In A3, put
=A2+0.5
and copy down as far as needed.

The result differs from the ideal by capitalization of a few letters.

Hope this helps getting started.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill for dates? George Excel Programming 2 May 18th 06 04:51 AM
Auto fill dates Jennifer Excel Worksheet Functions 1 March 24th 06 08:45 PM
Auto fill dates Jennifer Excel Worksheet Functions 0 March 24th 06 08:32 PM
auto fill row with dates tdennis14 Excel Discussion (Misc queries) 5 October 27th 05 01:53 AM
Auto- Fill Dates? DangerMouse114[_13_] Excel Programming 2 June 7th 04 05:53 AM


All times are GMT +1. The time now is 12:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017