Richardeye came up with this great formula. I realize that I need the year to change as time passes. The formula gives the number of days from the first of the year until the day before the entered date.
Is there a way to make the formula change the year automatically based on the year in the date instead of a manual change?
Example: if the date was 3/31/06 (C1), change the formula automaticaly from
=C1-DATE(2005,1,1)
To read
=C1-DATE(2006,1,1)
C1= DATE CELL
Bookmarks