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...
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!