Cumulative total by fortnight

[jrodmc]

Hi guys

I must admit Im pretty amateur with Excel and am trying to do something that's way over my head.

Basically, all I need to do is have a cumulative total in one cell that adds the same figure each fortnight. ie, adding 100 each fortnight would give me 500 after five fortnights.

Im assuming it needs to run off the date on my pc, and I've managed to figure that out with =TODAY(). What I cant figure out is how I would set a start date and then set my fortnightly figure to be added. Presumably then the formula would state "if today is 14 days (or divisibly by 14 days) greater than start date, add an extra increment"

I hope I've explained this well enough, let me know if anyone needs any clarification

 

[cyrilbrd]

Hi,

would you have a cell with the starting date? such as in A2 then B2 could be =(TODAY()-A2)*100

 

[p45cal]

something like:
=INT((TODAY()-DATE(2012,2,8))/14)*100
where I've used the start date 8th Feb 2012

 

[Robert Mika]

This should do the trick
IF A1 is your start date:
=ROUNDDOWN((TODAY()-A1)/14,0)*100

 

[cyrilbrd]

Hi Robert, don't you mean =ROUNDDOWN((TODAY()-A1),0)*100

??

 

[Robert Mika]

Hi Robert, don't you mean =ROUNDDOWN((TODAY()-A1),0)*100

??

Hi cyril,
The request was every 14 days or I'm missing something...

 

[cyrilbrd]

Hi cyril,
The request was every 14 days or I'm missing something...

Nope you are certainly correct, I most likely misunderstood that statement.
Thought the OP gave another example... the "presumably" set me off course.

 

[jrodmc]

Awesome, thanks guys. both the "rounddown" and "int" formulas work.