Datedif - 20 days

Hello..

I'm creating a spreadsheet to help me track dates a store procedure ran. In column A, I have dates as such...

Friday, February 01, 2013
Saturday, February 02, 2013
Sunday, February 03, 2013


and so on.

In column B I would like to show what the date was 20 days prior like so

Friday, February 01, 2013 Saturday, January 12, 2013
Saturday, February 02, 2013 Sunday, January 13, 2012
Sunday, February 03, 2013 Monday, January 14, 2013

Any ideas on how I can accomplish this?

If those are proper dates in Excel, rather than text values which look like a date, then you should be able to do:

=A1-20

in B1. Format the cell how you wish to see it.

Hope this helps.

Pete

I was way over thinking this one.. It worked perfectly Pete. Thanks!!