Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and Text in one formula
I am trying to write a formula which has text and then a date which is taken from a different sheet in the workbook. EG the text is "Nav as at 31st March 06" With 'Nav as at' being the text and the date 31st March being picked up from the other sheet. However the date on the other sheet is the following month, ie 30th June. SO I would need it to pick up the End of the month and minus it by one month and add it to the text. I have tried several methods but none seem to work!! Thanks Caroline -- CarolineHedges ------------------------------------------------------------------------ CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705 View this thread: http://www.excelforum.com/showthread...hreadid=554904 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text File creates incorrect Date format | Excel Discussion (Misc queries) | |||
Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
HOW DO I ENTER THIS FORMULA TO CONVERT TEXT TO DATE =DATEVALUE(, | Excel Worksheet Functions | |||
Can a conditional formula indicate "date added" next to a text? | Excel Worksheet Functions | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) |