#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
VB Code in Excel Active worksheet | shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |