| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Date formula question
Hi,
Was wondering if someone could help me with a problem I am having with a date in excel. I am trying to have a hybrid cell featuring both text and a date. The date is located in another cell, on another worksheet, and is being pulled through to the cell (there is a good reason for this). My current formula looks similar to this. ="Week Commencing"&+Page1!D23 What I end up getting is Week Commencing 39363, instead of Week Commencing 10/10/07. If I remove the text part of the formula I get the correct date. I have played around within format cell but can't get the date to display correctly. I would be grateful if someone could give me an idea of how to solve this! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Date formula question
="Week Commencing"&TEXT(Page1!D23,"dd/mm/yy")
Regards, Stefi ezt *rta: Hi, Was wondering if someone could help me with a problem I am having with a date in excel. I am trying to have a hybrid cell featuring both text and a date. The date is located in another cell, on another worksheet, and is being pulled through to the cell (there is a good reason for this). My current formula looks similar to this. ="Week Commencing"&+Page1!D23 What I end up getting is Week Commencing 39363, instead of Week Commencing 10/10/07. If I remove the text part of the formula I get the correct date. I have played around within format cell but can't get the date to display correctly. I would be grateful if someone could give me an idea of how to solve this! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Date formula question
Hi Gareth
Try ="Week Commencing"&TEXT(Page1!D23,"dd/mm/yyyy") -- Regards Roger Govier wrote in message oups.com... Hi, Was wondering if someone could help me with a problem I am having with a date in excel. I am trying to have a hybrid cell featuring both text and a date. The date is located in another cell, on another worksheet, and is being pulled through to the cell (there is a good reason for this). My current formula looks similar to this. ="Week Commencing"&+Page1!D23 What I end up getting is Week Commencing 39363, instead of Week Commencing 10/10/07. If I remove the text part of the formula I get the correct date. I have played around within format cell but can't get the date to display correctly. I would be grateful if someone could give me an idea of how to solve this! Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Date formula question
Perfect! Thanks guys! :-)
Roger Govier wrote: Hi Gareth Try ="Week Commencing"&TEXT(Page1!D23,"dd/mm/yyyy") -- Regards Roger Govier wrote in message oups.com... Hi, Was wondering if someone could help me with a problem I am having with a date in excel. I am trying to have a hybrid cell featuring both text and a date. The date is located in another cell, on another worksheet, and is being pulled through to the cell (there is a good reason for this). My current formula looks similar to this. ="Week Commencing"&+Page1!D23 What I end up getting is Week Commencing 39363, instead of Week Commencing 10/10/07. If I remove the text part of the formula I get the correct date. I have played around within format cell but can't get the date to display correctly. I would be grateful if someone could give me an idea of how to solve this! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formula question | Excel Discussion (Misc queries) | |||
| Excel Date Formula Question | Excel Discussion (Misc queries) | |||
| formula date question? | Excel Discussion (Misc queries) | |||
| formula date question? | Excel Discussion (Misc queries) | |||
| Formula date question | Excel Discussion (Misc queries) | |||
Linear Mode
