Software

Ask something
Discussion Locked

Excel Formula Question

0 helpful
7 replies

by jeffryg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been given an excel spread sheet that will need to be updated every 2
weeks. This spreadsheet has an insertion date, then a due to magazine date
and from there I need to calculate -7 dates from magazine date, -1 day from
that and -6 days from that- can e

How can excel calculate dates for me. Example June 5 - 7 days = ____ -1 day
=____-6 days ____.

Thanks- can't find formula anywhere....I have a lot of these to calculate
every two weeks.

7 replies

by buckle

I have excel 97 and used the "Date & Time" functions found at "Insert">"Function..." You will have to change the cell format of the answer cell from date to number.

by rmccon

In excel 2000 you can just put in the formula ="Cell with date" - 7.

Good luck

Rob

by el flush san

Yes ... for instance if your insert date is in cell a4 then your calculation should be =a4-7 (assume this to be in c4); the next would then be =c4-1 (assume this to be in F4); and the last would be =F4-6.

This discussion is closed to new replies.