| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format
hey all, I have worked out the first and last day of the month by using these formulas cell A1 is =NOW() cell B1 is =DATE(YEAR(A1), MONTH(A1),1) cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0) and now I want the results of B1 and C1 in one cell which I thought I could do with, cell D1 is =b1&" - "&c1 but everytime I try this I loose the date format in D1 and I can't get it back. Anyone got any ideas. Cheers -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=506733 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Threaded Mode
