Date minus 2 days back

[mjshort88]

Hello

I've been trying to get this formula working but with no such luck.

I'm trying to get a cell to calculate 2 days back from another date in a cell.

any help would be much appreciated.

Thank you,

Mk

[NBVC]

You can just use subtraction.

Eg. A2-2 where A2 contains the original date.

you may need to format the result cell as date to look right.

[mjshort88]

Wow! very easy and it works! Thank you.

if the date that had been taken back 2 days landed on a weekend (Sat, Sun) could i force it to go to the previous Friday?

Thanks again!

[NBVC]

Try:

=E1-IF(WEEKDAY(E1-2,2)=6,3,IF(WEEKDAY(E1-2,2)=7,4,2))

[mjshort88]

Thank you! It worked! Legend man.

I made a little change because i wanted it to go back 2 days no matter what the day was. So if it was Monday it went back to Friday but i needed 2 days back, so i changed it to

=E1-IF(WEEKDAY(e1-2,2)=6,4,IF(WEEKDAY(E1-2,2)=7,4,2))

That seems to work, does it look ok? i just changed to 3 to a 4!

Thank you

[NBVC]

If that is the case, I wonder if this would work.

=WORKDAY(E1,-2)

This is an Analysis Toolpak function.. If you get a #NAME! error, then go to Tools|Addins and select Analysis Toolpak.