Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2019, 09:12 AM
oliboi oliboi is offline How to show days remaining Windows 10 How to show days remaining Office 2016
Novice
How to show days remaining
 
Join Date: Feb 2016
Location: Canada
Posts: 20
oliboi is on a distinguished road
Default How to show days remaining


I have an Excel document where I am inserting information about booking certain rooms in a building. We have a certain amount of days available that we can book rooms. For example, we are permitted only 35 weekdays room bookings rentals dates.

I want to show on my Excel document that anytime I fill in a row with a new booking date information, there is a cell with a number that always goes down with the remaining number of rental days available. I am wondering what is the best way to show this.
Attached Files
File Type: xlsx Permits for use of school property.xlsx (15.9 KB, 15 views)

Last edited by oliboi; 01-24-2019 at 09:01 AM.
Reply With Quote
  #2  
Old 01-23-2019, 10:18 AM
NoSparks NoSparks is offline How to show days remaining Windows 7 64bit How to show days remaining Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Assistance would be more likely (and accurate) if you attach a sample sheet of what you're working with.
Reply With Quote
  #3  
Old 01-23-2019, 10:30 AM
oliboi oliboi is offline How to show days remaining Windows 10 How to show days remaining Office 2016
Novice
How to show days remaining
 
Join Date: Feb 2016
Location: Canada
Posts: 20
oliboi is on a distinguished road
Default

Thanks. Just attached it.
Reply With Quote
  #4  
Old 01-24-2019, 12:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to show days remaining Windows 7 64bit How to show days remaining 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

Thank you for the trouble, but I think NoS asked for a sheet , not a picture (click Go advanced - Manage attachments - follow the wizard)
__________________
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 01-24-2019, 09:00 AM
oliboi oliboi is offline How to show days remaining Windows 10 How to show days remaining Office 2016
Novice
How to show days remaining
 
Join Date: Feb 2016
Location: Canada
Posts: 20
oliboi is on a distinguished road
Default

I have attached the file
Reply With Quote
  #6  
Old 01-24-2019, 10:18 AM
NoSparks NoSparks is offline How to show days remaining Windows 7 64bit How to show days remaining Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

I think what you're after is the NETWORKDAYS function as it excludes weekends (and can exclude holidays).
see https://exceljet.net/formula/get-workdays-between-dates

You are aware that what you have in column C is text and not real dates, right ?
All of which are in the past and don't have any weekdays remaining.
Should it be that you have another column for the length of the bookings or something ?
Perhaps you can elaborate as to what you're after.
Reply With Quote
  #7  
Old 01-24-2019, 10:29 AM
oliboi oliboi is offline How to show days remaining Windows 10 How to show days remaining Office 2016
Novice
How to show days remaining
 
Join Date: Feb 2016
Location: Canada
Posts: 20
oliboi is on a distinguished road
Default

I might actually also add weekends in the future so I guess NETWORKDAYS function will not work for me.
Yes, I have text for dates. I was trying to figure out how to put an actual calendar there (so I don't have to write the date everytime) but I haven't figured that out yet.
Yes, I will have another column for the length of the bookings.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Confusion between Licensed and Remaining Grace (too short) glnz Office 0 08-13-2016 06:15 AM
How to show days remaining Sum the (filtered) remaining work column brentcfocus Project 3 03-21-2016 08:34 PM
Time Remaining Progress Bar teza2k06 Excel 1 05-13-2014 05:41 AM
How to show days remaining adjusting remaining work per status date ketanco Project 1 03-16-2012 06:02 AM
remaining duration vs finish date ketanco Project 3 02-17-2012 02:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:54 AM.


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