CODEWITHSUNDEEP
excelexcel-formula
Mercsadies
Mercsadies

Reputation: 3

Excel formula to create a date range based upon one date that will be manually entered

I need help with creating the formula that will fill one cell with a date range. I manually enter the date (example: 8/19/18) and I need the calculation to give me 8/12/18 - 8/18/18.

Basically, I am entering the "issued date" and from that, I want the previous week's date range to be seen.

I know this isn't right ... but my basic skills would tell me it's something like: =(E8-7) - (E8-1) where E8 would be the manually filled in date of 8/19/18

Thank you for any help or direction!

Upvotes: 0

Views: 44

Answers (1)

BruceWayne
BruceWayne

Reputation: 23283

You're so close! You need to use TEXT() to format in to the mm/dd/yy you want:

=TEXT((E8-7),"mm/dd/yy")&" - "&TEXT((E8-1),"mm/dd/yy")

Upvotes: 2

Related Questions