Formula For Displaying Exact Days of the Month

		Microsoft Office Forums > Microsoft Excel > Excel
Formula For Displaying Exact Days of the Month

FAQ

Thread Tools

Display Modes

07-12-2016, 10:46 AM

ddhawks

Windows 10 Formula For Displaying Exact Days of the Month

Office 2000

Novice

Join Date: Jul 2016

Posts: 1

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!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Configure for 30 days, not calendar month	teapea21	Outlook	1	07-31-2014 09:05 AM
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
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 07:05 PM.