ExcelBanter - How to show date in H2 based on date in I2 minus set number of day

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to show date in H2 based on date in I2 minus set number of day (https://www.excelbanter.com/excel-discussion-misc-queries/172167-how-show-date-h2-based-date-i2-minus-set-number-day.html)

jt24

How to show date in H2 based on date in I2 minus set number of day

I have a worksheet that shows projected due dates for reports in column I and
I want to show due dates in columns F, G and H based on 65, 58 and 44 days
before the date that is in column J. Can anyone help me with this one?

David Biddulph[_2_]

How to show date in H2 based on date in I2 minus set number of day

=I2-65
=I2-58
=I2-44
--
David Biddulph

"jt24" wrote in message
...
I have a worksheet that shows projected due dates for reports in column I
and
I want to show due dates in columns F, G and H based on 65, 58 and 44 days
before the date that is in column J. Can anyone help me with this one?

jt24

How to show date in H2 based on date in I2 minus set number of

Thanks for the help. :) You have made my life easier.

"David Biddulph" wrote:

=I2-65
=I2-58
=I2-44
--
David Biddulph

"jt24" wrote in message
...
I have a worksheet that shows projected due dates for reports in column I
and
I want to show due dates in columns F, G and H based on 65, 58 and 44 days
before the date that is in column J. Can anyone help me with this one?

All times are GMT +1. The time now is 12:40 PM.