Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2015, 02:48 AM
kenbird kenbird is offline Excel Calendar in a worksheet Windows 7 64bit Excel Calendar in a worksheet Office 2010 64bit
Novice
Excel Calendar in a worksheet
 
Join Date: Apr 2015
Posts: 1
kenbird is on a distinguished road
Cool Excel Calendar in a worksheet

I have recently developed a spreadsheet in Excel 2010 that calculates the cost of a tour that is limited by the number of days which are 5, 7 and 13. The attachment makes this clearer.



In the same spreadsheet is an excel calendar which I want updated using a function if the tour dates = 5 or 7 or 13.

The update to the calendar must be by colour which I have shown in the attachment called "test spreadsheet."

Using the attachment I have booked a 5 day tour between the dates 4-8 May 2015. When I do that I want the dates in the calendar to be coloured "red." I have shown two other examples for 7 days between 11 and 17 May 2015 (colour = "yellow") and 13 days between 25 May and 5 June 2015 (colour = "green").

I need a formula which updates the excel calendar when the dates are shown for 5 or 7 or 13 day tours.
Attached Files
File Type: xlsx test spreadsheet.xlsx (48.0 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Calendar in a worksheet Email Hyperlink to excel worksheet Shaz Outlook 2 08-03-2014 11:46 PM
Paste special an Excel range into Outlook as an Excel Worksheet charlesh3 Excel Programming 3 02-04-2013 04:33 PM
Excel - Color Worksheet Tabs avie layne Excel 4 11-12-2012 04:45 PM
Distortion trying to embed excel worksheet Sugaratias Word 0 11-26-2011 11:26 AM
Excel Calendar in a worksheet VB Code in Excel Active worksheet shakilhyd Excel 2 05-17-2010 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft