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.