Excel Formula utilizing a start date & updates every 7 d

[BlueJaguarXJS]

I'm having trouble creating an excel formula for our HR Department. They want their spreadsheet to have a start date and every seven days (week) it will add .89 the the original number in the start date cell. IF anybody could steer me in the right direction? I would greatly appreciate it. Thanks, Will

 

[Oaktree]

Welcome to the board!

How about:

=B1+0.89*INT((TODAY()-A1)/7)

Where A1 is the start date and B1 is the initial amount to which the 0.89's are added.

 

[barry houdini]

Hi welcome to the board.

Your request isn't particularly clear to me.

You have a date in a cell (call it A1) and you want to increment a value (call it B1) by 0.89 every 7 days from that date? If so then perhaps

=B1+INT((TODAY()-A1)/7)*0.89