Forum Discussion
Formula to calculate dates
I'd like to figure out how to insert a formula to help determine the due date for a given award. There are three awards and each has a different time requirement based on the DEROS date. I can't seem to figure out how to make it all talk to each other.
8 Replies
With do it yourself instructions :))
English: =IF(G3="X",('Sheet1 (2)'!C3-Sheet2!B2),"")
Have fun with Excel
NikolinoDE
Broadly speaking, all that is required is to add or subtract the intervals, measured in days or part thereof, from the base date. For example
The formulae differ slightly when the source is an Excel table or using a non-dynamic array version of Excel.
Thank you for taking a look. I've attached the workbook. Simply put, if an award of an ARCOM is received (annotated with an 'X') then the dates for CO, BN, and BDE are all based on the DEROS date. The second sheet contains the spread of days.
I need the sheet to calculate the correct number of days regardless of what award (ARCOM, AAM or MSM) has the 'X' in the box. I hope that makes more sense!
Maybe this link will help you further.
If not, as Mr. Basklan has already written to you, please insert a file (no picture) (without sensitive data), as the Excel version and operating system would be advantageous.
Above all an advantage for you (this will allow you to come up with a solution proposal much faster and more precisely) and for the helpers who do not need to waste time on the basics.
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
Sorry, I didn't catch what is required
"There are three awards..." - where they are? Better it terms of Excel, which cells you mean?
"...and each has a different time requirement" - which one?
- For example, an award called ARCOM needs to be done at the CO level 65 days prior to the stated DEROS date. At the BN level, 60 days prior to the DEROS date. Does that make sense? Thank you so much for your willingness to help!
That's not clear what you'd like Excel tp show and in which cell(s) and how Excel knows how many days (60, 65) for this or that level and where these levels are. Or that's all shall be hardcoded within formulas?
