Solved: Formula to Add to date Change

[sooty8]

Hi All

This will be hopefully an easy question to answer - my year starts on the 1st October today being 24th November it is 54 days since the year commenced.
In cell K1 I have =Today() In Cell L1 is the number 54. When the date changes what formula would I enter to change the number in L1 to 55 and so on for everytime the date changes.

Many thanks
Sooty8

[Bob Phillips]

Use

=N(TODAY()-"2012-10-01")

[omp001]

=IF(MONTH(K1)>=10,K1-DATE(YEAR(K1),10,1),K1-DATE(YEAR(K1)-1,10,1))

[sooty8]

Hi Xld

Thank you - as usual spot on

Omp001 within you formula unfortunately there is a circular reference error