LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 1-2-3 @ function to Excel Assistance

No, this does not mean that 82.5% of a year has elapsed - think about
it: it is now March and the reference date was in January of last year,
so more than one year has elapsed. Alternatively, the reference date
was 1st October, so we are now about half a year past that date (I
don't know if you are working with mm/dd/yy or dd/mm/yy format dates).

You need to put a date in cell H13 for it to work correctly. If you
make it 20/03/2006, then you should get 1.189041, and you need to
format this cell as percentage with no decimal places if you want it to
show 119%. To follow the alternative date format, enter 03/20/2005 and
you will get 47%.

If you want to avoid spurious values, then change the formula to this:

=IF(H13=0,"",(H13-DATEVALUE("10/01/2005"))/365)

This will give you a blank result if there is nothing in cell H13.

Hope this helps.

Pete

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i execute a VBA function by clicking on an excel cell? Matthew Excel Discussion (Misc queries) 1 December 7th 05 01:10 AM
Excel 2003 Slow Function Argument Window [email protected] Excel Discussion (Misc queries) 2 June 28th 05 06:53 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Access Module coded converted to Excel Function Adam Excel Discussion (Misc queries) 1 December 23rd 04 02:48 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"