Date Formula

[Rodney Jorgensen]

I am working on a formula to calculate 7 days prior to a certain date, and can't quite seem to figure out where I am going wrong.

I have:

=MONTH((A15)+DAY(A15-7)+YEAR(A15))

Thanks for your help.

 

[KSTWS]

=a15-7

 

[Rodney Jorgensen]

So Simple, I overlooked even trying that???

Thanks

 

[jeffreybrown]

Hi Rodney,

I know you have your answer, but with the formula you originally tried it is close, just needed a little modification.

=DATE(YEAR(A15),MONTH(A15),DAY(A15)-7)

 

[Rodney Jorgensen]

Thanks... I was close.