Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date Range Formular Date Range Formular
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-21-2017, 07:04 PM
Colin C Colin C is offline Date Range Formular Windows 10 Date Range Formular Office 2016
Novice
Date Range Formular 		 
Join Date: Apr 2017
Posts: 2
Colin C is on a distinguished road
Cool Date Range Formular
Hi hope someone can help see attached spread sheet I need the column G in Red to result in the date range selection Its driving me crazy?



Colin
Attached Files
File Type: xlsx Book1.xlsx (10.5 KB, 20 views)
Reply With Quote
  #2  
Old 04-21-2017, 08:18 PM
Logit Logit is offline Date Range Formular Windows 10 Date Range Formular Office 2007
Expert
  
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
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.
Reply With Quote
  #3  
Old 04-21-2017, 11:58 PM
Colin C Colin C is offline Date Range Formular Windows 10 Date Range Formular Office 2016
Novice
Date Range Formular 		 
Join Date: Apr 2017
Posts: 2
Colin C is on a distinguished road
Default
Thanks you
Reply With Quote
  #4  
Old 04-22-2017, 12:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Range Formular Windows 7 64bit Date Range Formular 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
Quote:
Originally Posted by Logit View Post
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.
Wouldn't =TEXT($G$2,"dd-mmm-yy")&" - "&TEXT($G$3,"dd-mmm-yy")
allow to drag down?
__________________
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
  #5  
Old 04-22-2017, 09:34 AM
Logit Logit is offline Date Range Formular Windows 10 Date Range Formular Office 2007
Expert
  
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Pecoflyer

For some reason, not on my computer.
Reply With Quote
  #6  
Old 04-22-2017, 11:46 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Range Formular Windows 7 64bit Date Range Formular 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
Quote:
Originally Posted by Logit View Post
Pecoflyer

For some reason, not on my computer.
And what happens when you try?
__________________
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
Microsoft Project 2016 print specific date range stuck on one date martinsalmon Project 1 10-12-2016 11:36 AM
Date Range Formular 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 Formular 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 03:57 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