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