Counting Days

Derpeder

New Member
Joined
Oct 24, 2006
Messages
18
I simply would like to count from today up. Everyday a day goes by I want it to add a day so first day the box reads 1 then the next day the box reads 2 and so on.

Can someone help me out on that?

Thanks
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
I would suggest a static date in one cell and a today() formulae in anouter and another with a dated if formulae in it. this will then count the day difference betweeen the 2 dates..
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
=DATEDIF(C8,TODAY(),"md")

c8 being the date you would like to start the count from....
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
you could do as bsnapool suggested with 1 less fomula.

cell a1 contains static date you decide as a starting point

cell a2 =today()-a1

format cell a2 as number, NOT date.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,877
Members
409,668
Latest member
mitunsLax

This Week's Hot Topics

Top