Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
Hi everyone,
Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
=A1 & "/" &A2 & "/" &A3 will give text, rather than a date, but =--(A1 & "/"
&A2 & "/" &A3) will give a date (if the cell is formatted appropriately). In some cases, if you try to do calculations based on the cell containing text, it will translate it to a date in the calculation. -- David Biddulph "Neon520" wrote in message ... Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
Another option, of course, is =DATE(A3,A2,A1)
-- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... =A1 & "/" &A2 & "/" &A3 will give text, rather than a date, but =--(A1 & "/" &A2 & "/" &A3) will give a date (if the cell is formatted appropriately). In some cases, if you try to do calculations based on the cell containing text, it will translate it to a date in the calculation. "Neon520" wrote in message ... Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
Hi,
Yes A1 & "/" &A2 & "/" &A3 will be a date and to demonstrate that add to to it in another cell and that will be the next day. For your age follow on with your logic and use this =DATEDIF(A1 & "/" &A2 & "/" &A3,TODAY(),"y") Mike "Neon520" wrote: Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
say A1 has 1
say A2 has 18 say A3 has 2000 =DATE(A3,A1,A2) will display as 1/18/2000 - an Excel-style date -- Gary''s Student - gsnu200765 "Neon520" wrote: Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Date Format" v.s. "##/##/####"
Thanks Mike and Gary's Student, that's really helpful!!!
"Mike H" wrote: Hi, Yes A1 & "/" &A2 & "/" &A3 will be a date and to demonstrate that add to to it in another cell and that will be the next day. For your age follow on with your logic and use this =DATEDIF(A1 & "/" &A2 & "/" &A3,TODAY(),"y") Mike "Neon520" wrote: Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and combine them using & sign? For ex, A1 & "/" &A2 & "/" &A3. If after combining the three number, will Excel still look at the combined cell as a "date". I need to do some calculating with the combined cell, and I want Excel to look at it as a date, let's say I need to calculate the age, but the birth date need to be hidden. How can I do with this? Thanks, GU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |