| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help asap
If you have two dates in A1 and B1, then you can enter this formula in
C1: =ABS(A1-B1)/365 and format C1 as a number. This will give you the difference in the dates in years (approximately, as there are 365.25 days in a year on average). Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where do I download ASAP utilities for Excel? Thanks | Excel Discussion (Misc queries) | |||
| Making form using Excell Help ASAP! | Excel Discussion (Misc queries) | |||
| need to make a template for weekly calendar ASAP that shows pictu. | Excel Discussion (Misc queries) | |||
| Help with Protections ASAP | Excel Worksheet Functions | |||
| Finding decreased value PLEASE HELP ASAP! | Excel Worksheet Functions | |||
Threaded Mode
