Excel Formula utilizing a start date & updates every 7 d

BlueJaguarXJS

New Member
Joined
Nov 28, 2005
Messages
1
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 :eek:
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,727
Messages
5,573,861
Members
412,555
Latest member
mark84
Top