To work out how many days, weeks, months to I retire on 20 Sep
"Jacob Skaria" wrote:
With retire date in A1
Days =DATEDIF(TODAY(),A16,"d")
Weeks = =DATEDIF(TODAY(),A16,"d")/7
Month =DATEDIF(TODAY(),A16,"m")
Years =DATEDIF(TODAY(),A16,"y")
If this post helps click Yes
---------------
Jacob Skaria
"Using the date functions" wrote:
Hi, thanks to any one who can help.
I'm using Excell 2000 and would like to do the above in a exsisting wookbook.
Sad I know, but my other hobby is digital photography, and that is takeing
all my thoughts.
Thanks
Many Thanks Jacob.
|