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
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