| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date reference to another cell
Hi all
[Excel 2010 on windows 7] I am having a problem with the following: On a sheet called Client Details in cell B23 is a date, 31 October 2011 In a cell on another sheet I want this to show: The agreement is scheduled to commence on 31 October 2011 including providing the management representation letter I inserted this: ="The agreement is scheduled to commence on " & format('Client Details'!B23,"dd MMM yyyy") & " including providing the management representation letter." This is what I get #NAME? If I don't format the the 'Client Details'!B23 I get a Julian date number, 40847 not very useful! Please can somebody help Thanks Peter www.automatexcel.co.za |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed on date matching and cell reference. | Excel Worksheet Functions | |||
| Delete columns based on a cell reference date value | Excel Programming | |||
| problem with cell reference and date | Excel Programming | |||
| Inserting current date when number entered in cell & Circular reference error? | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
![Peter Bircher[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
