for e.g. if the date is 31 -dec-2001, how do i convert to 30-dec-2007
B Bob Phillips Feb 12, 2007 #2 =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
B Bob Phillips Feb 12, 2007 #3 =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
S sharita Feb 12, 2007 #4 THANKS SO VERY MUCH........IT WORKED Bob Phillips said: =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
THANKS SO VERY MUCH........IT WORKED Bob Phillips said: =DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)) assuming that date is in A1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Click to expand...
