Date Range Formular

		Microsoft Office Forums > Microsoft Excel > Excel
Date Range Formular

04-21-2017, 08:18 PM

Logit

Windows 10 Date Range Formular

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

=TEXT(G2,"dd-mmm-yy")&"  -  "&TEXT(G3,"dd-mmm-yy")

You will have to copy and paste into each cell you want the dates displayed.
You will not be able to paste and drag down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Project 2016 print specific date range stuck on one date	martinsalmon	Project	1	10-12-2016 11:36 AM
Find if Date range falls within another range	Triadragon	Excel	3	05-02-2016 11:48 AM
Find a Date in a Range	rspiet	Excel	3	02-15-2016 08:37 AM
Check if a Date falls within a date range	OTPM	Excel	7	02-03-2016 09:11 PM
Date Range Prompt	MikeWooZ	Excel	6	12-04-2011 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:25 PM.