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

J

jt24

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Day of month to Date in month 2
Date Range Changing Each Time Worksheet Is Opened 2
Sum of multiple rows, based on date criteria, separate sheets... 0
autofill colour based on date entered 4
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Day & date shading 3
Conditional Formatting – Due Date, Warning - Completion 1
Conditional Formatting – Due Date, Warning - Completion 1

Top