| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
=TEXT(B1,"dd/mm/yyyy")&" - "&TEXT(C1,"dd/mm/yyyy")
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Hru48" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
Modify the data values to strings using this variant of your existing formula:
=Text(b1,"m/d/yyyy")&" - "&Text(c1,"m/d/yyyy") If you want different date formats, you can use "dddd, mmmm d, yyyy", "yy-mmm-dd", just to name a few... -- Kevin Backmann "Hru48" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format
Many thanks all! -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=506733 |
| Reply |
| 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) | |||
Linear Mode
