|
|
#7
12-25-2010, 07:34 AM
|
|||
|
|||
I should have looked at the template before posting (I would have realized there is a column to enter dates, not just a cell), but here is the formula, just a simple VLOOKUP is all that is needed. Assuming the calendar range begins with C5, and the dates will be entered in A1:A30...
=VLOOKUP(C5,$A$1:$A$40,1,0) 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Age Calculator in MS Outlook 2002 SP3 | turns | Outlook | 0 | 06-15-2010 12:26 AM |
 Opening multiple Excel files within the same Excel window.
|
lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
| How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode