PDA

View Full Version : Solved: Formula to Add to date Change



sooty8
11-24-2012, 12:44 PM
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
11-24-2012, 03:10 PM
Use

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

omp001
11-24-2012, 04:05 PM
=IF(MONTH(K1)>=10,K1-DATE(YEAR(K1),10,1),K1-DATE(YEAR(K1)-1,10,1))

sooty8
11-25-2012, 03:10 AM
Hi Xld

Thank you - as usual spot on

Omp001 within you formula unfortunately there is a circular reference error