Forum menu
Topic starter
How to make a cell counts #of days backwards?
Example:
Feb 12 ......(A1 cell appears =12 )
Feb 13 ......(A1 cells appears = 11)
Feb 14.....(A1 cells appears = 10)
And in the next month
March 01 (A1 cell goes back to =31) so on so forth..
But this is automated and relies calendar date on the pc calendar itself.. Is this possible 😐
And that example A1 cell #of days remaining... I will need to get that data to divide the remaining locations per day.. At the moment i just doing it manually..cheers ..if only possible though 🙂
Posted : 13/02/2014 2:10 am
What are you counting backwards from? What date is zero?
You can use the date you enter minus the'zero' date and use abs() to ensure it always shows a positive value.
Posted : 13/02/2014 10:03 am
=day(eomonth(A1, 0))-day(A1)
where A1 is your date.
Posted : 13/02/2014 10:06 am