Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date and name to auto update within one cell
Hello,
How can I add a date and name to update in a cell? Currently I have =NOW() within the same cell I want to add a name (probably from a list). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date and name to auto update within one cell
You will probably want to format the date before joining it to a name,
and if you only want a date then you can use TODAY rather than NOW (which gives you a time as well). So, try this: =TEXT(TODAY(),"dd/mm/yy")&"your_name" where "your_name" can be a cell reference, or a formula which returns a name from a list. Hope this helps. Pete On Jun 25, 9:34*pm, Cathie G wrote: Hello, How can I add a date and name to update in a cell? Currently I have =NOW() within the same cell I want to add a name (probably from a list). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date and name to auto update within one cell
Thank you for the answer. This sort of solves my problem. I have two columns
M7 and N7. M7 is Revised Date and N7 is Revised by. What I need is once these are updated I need the name and date to fall into B1 "Pete_UK" wrote: You will probably want to format the date before joining it to a name, and if you only want a date then you can use TODAY rather than NOW (which gives you a time as well). So, try this: =TEXT(TODAY(),"dd/mm/yy")&"your_name" where "your_name" can be a cell reference, or a formula which returns a name from a list. Hope this helps. Pete On Jun 25, 9:34 pm, Cathie G wrote: Hello, How can I add a date and name to update in a cell? Currently I have =NOW() within the same cell I want to add a name (probably from a list). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a date and name to auto update within one cell
Well, put this formula in B1:
=IF(OR(M7="",N7=""),"",TEXT(M7,"dd/mm/yy")&N7) This will show a blank in B1 if either of the other two cells are empty - both have to contain data for the result to show. Hope this helps. Pete On Jun 25, 10:57*pm, Cathie G wrote: Thank you for the answer. *This sort of solves my problem. I have two columns M7 and N7. *M7 is Revised Date and N7 is Revised by. *What I need is once these are updated I need the name and date to fall into B1 "Pete_UK" wrote: You will probably want to format the date before joining it to a name, and if you only want a date then you can use TODAY rather than NOW (which gives you a time as well). So, try this: =TEXT(TODAY(),"dd/mm/yy")&"your_name" where "your_name" can be a cell reference, or a formula which returns a name from a list. Hope this helps. Pete On Jun 25, 9:34 pm, Cathie G wrote: Hello, How can I add a date and name to update in a cell? Currently I have =NOW() within the same cell I want to add a name (probably from a list).- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
auto update of date | Excel Worksheet Functions | |||
How to auto update date contained in formula | New Users to Excel | |||
How to auto update a cell with a current date | Excel Discussion (Misc queries) | |||
canceling auto date update | New Users to Excel |