Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates from Text
Hi,
I have a spreadsheet of Public Holidays for different countries. The dates are in thye following format 1st January (for New Years Day) with no YEAR. This format is used as the list can be viewed by people using both UK date format (dd/MM/yyyy) and US format (MM/dd/yyyy), and will be used for couple of years. I would like to add the year to it using (Year(NOW()) to get this date 1st January 2008, and get the day of the week, in this case Tuesday. I know about DATEVALUE. The problem I have is getting from 1st January to 01/01/2008. I tried CONCATENATE("DATECELL", " ", Year(NOW())). This returns 1st January 2008, but DATEVALUE on this date returns #VALUE. Any help would be much appreciated. Thanks and Regards Claudio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
Format text 'dates' to real dates | Excel Worksheet Functions | |||
dates and text | Excel Discussion (Misc queries) | |||
dates and text | Excel Discussion (Misc queries) | |||
Text with Dates | Excel Discussion (Misc queries) |