rossmcl
Programmer
- Apr 18, 2000
- 128
Anyone know how to get a fraction between 0 and 1 depending on the day of the year.<br><br>ie 1st July would be 0.5<br><br>31st Dec would be 1<br><br>1st Jan would be 0<br><br>Any help much appreciated
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
**EXCEL POSER**
- Thread starter rossmcl
- Start date
- Status
how accurate do u need it?(does it need to show, say the 12th, 13th, 14th, days of the month or just the first?)<br><br>and what is the purpose??<br><br>please <p>Peter Heaton<br><a href=mailto:heaton@characterlink.net>heaton@characterlink.net</a><br><a href= it how ever you want</a><br>
how accurate do u need it?(does it need to show, say the 12th, 13th, 14th, days of the month or just the first?)<br><br>and what is the purpose??<br><br>please tell a little more. <p>Peter Heaton<br><a href=mailto:heaton@characterlink.net>heaton@characterlink.net</a><br><a href= it how ever you want</a><br>
If Cell A1 has the date in it then the following formula seems to return the result you want (only works for year 2000 I suppose)<br><br>=(A1-36526)/365 <p>Dan Auber<br><a href=mailto
anAuber@aol.com>DanAuber@aol.com</a><br><a href= Auber's Home Page</a><br>
anAuber@aol.com>DanAuber@aol.com</a><br><a href= Auber's Home Page</a><br>- Status