| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
balance date
hi community
how can i find the balance date in the future date format, below is an example birthdate Age Target 60 years old balance date (yy-mm) - 60yrs 01-May-1957 51.6 01-May-2017 ?? how can i do the 4th column where I wish to know what is the date be example above is 8 years 6 months balance before reaching 60 years old can anybody assist me on this?? 10s community for the kind assistance given :) -- oldLearner57 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
balance date
Enter this in D1
=DATE(YEAR(A1)+51,MONTH(A1)+8,DAY(A1)) 8 years and6 months fromage at 60 years is same as 51 years plus 6 months from birth... "oldLearner57" wrote: hi community how can i find the balance date in the future date format, below is an example birthdate Age Target 60 years old balance date (yy-mm) - 60yrs 01-May-1957 51.6 01-May-2017 ?? how can i do the 4th column where I wish to know what is the date be example above is 8 years 6 months balance before reaching 60 years old can anybody assist me on this?? 10s community for the kind assistance given :) -- oldLearner57 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
balance date
Sorry for the typo
Use =DATE(YEAR(A1)+51,MONTH(A1)+6,DAY(A1)) with birthdate in A1 "oldLearner57" wrote: hi community how can i find the balance date in the future date format, below is an example birthdate Age Target 60 years old balance date (yy-mm) - 60yrs 01-May-1957 51.6 01-May-2017 ?? how can i do the 4th column where I wish to know what is the date be example above is 8 years 6 months balance before reaching 60 years old can anybody assist me on this?? 10s community for the kind assistance given :) -- oldLearner57 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
balance date
Hi,
If you want to use the date in column C instead of the number in column B, the following formula may do what you want: =YEARFRAC(TODAY(),C1,1) This will update daily and will display the results in years and fractional parts. If this helps, please click the Yes button Cheers, Shane Devenshire "oldLearner57" wrote: hi community how can i find the balance date in the future date format, below is an example birthdate Age Target 60 years old balance date (yy-mm) - 60yrs 01-May-1957 51.6 01-May-2017 ?? how can i do the 4th column where I wish to know what is the date be example above is 8 years 6 months balance before reaching 60 years old can anybody assist me on this?? 10s community for the kind assistance given :) -- oldLearner57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to add a set amount to a balance on a specific date | Excel Worksheet Functions | |||
| Returning a mortgage balance based on a particular date | Excel Discussion (Misc queries) | |||
| Keeping Balance Only | New Users to Excel | |||
| rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
| running balance | New Users to Excel | |||
Linear Mode
