| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calcutale 2 date with round date
i want a calculate 2 different date
eg. date of birth is 5 march 1984 if i add 25 years , it will be 5 march 2009 i want a result 31 march 2009. thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calcutale 2 date with round date
On Oct 24, 10:38 am, gohar wrote:
i want a calculate 2 different date eg. date of birth is 5 march 1984 if i add 25 years , it will be 5 march 2009 i want a result 31 march 2009. =eomonth(datevalue("5 march 2009"),0) Of course, you can generalize the DATEVALUE() part to your heart's content. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calcutale 2 date with round date
With the date in A1:
A1 = 5 March 1984 =DATE(YEAR(A1)+25,MONTH(A1)+1,0) -- Biff Microsoft Excel MVP "gohar" wrote in message ... i want a calculate 2 different date eg. date of birth is 5 march 1984 if i add 25 years , it will be 5 march 2009 i want a result 31 march 2009. thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date round-up | Excel Discussion (Misc queries) | |||
| Round date to first of month | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
