Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula For Displaying Exact Days of the Month Formula For Displaying Exact Days of the Month
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2016, 10:46 AM
ddhawks ddhawks is offline Formula For Displaying Exact Days of the Month Windows 10 Formula For Displaying Exact Days of the Month Office 2000
Novice
Formula For Displaying Exact Days of the Month 		 
Join Date: Jul 2016
Posts: 1
ddhawks is on a distinguished road
Default Formula For Displaying Exact Days of the Month
I'm making a monthly timesheet. I want the employee to be able to enter the start date and have Excel fill in the dates for the rest of the month.



I'm running into problems with months having fewer than 31 days because Excel fills in 31 days regardless. For example, June shows 06/01/16 though 07/01/16, and February shows 02/01/15 through 03/03/15.

How do I fix this?

Thank you!
Reply With Quote
  #2  
Old 07-12-2016, 09:07 PM
xor xor is offline Formula For Displaying Exact Days of the Month Windows 10 Formula For Displaying Exact Days of the Month Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Is it like shown in the attached?
Attached Files
File Type: xlsx Days_of_Month.xlsx (9.2 KB, 16 views)
Reply With Quote
  #3  
Old 07-12-2016, 11:48 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula For Displaying Exact Days of the Month Windows 7 64bit Formula For Displaying Exact Days of the Month Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Cross posted without links

http://www.excelguru.ca/forums/showt...s-of-the-Month
__________________
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
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula For Displaying Exact Days of the Month Configure for 30 days, not calendar month teapea21 Outlook 1 07-31-2014 09:05 AM
Formula For Displaying Exact Days of the Month Formula to divide if no of days in month is 28 shilabrow Excel 5 06-26-2014 12:17 AM
Formula for week days only gbaker Excel 5 02-15-2014 01:07 AM
Formula For Displaying Exact Days of the Month How to count even exact date 90 days redza Excel 1 09-17-2013 03:36 AM
Displaying work week in month view tupham Outlook 0 10-28-2008 02:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 PM.

Contact Us - Privacy Statement - Top

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