| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel, date
I have on cell that has an original manfg. date 1/1/90 (this date will
change) the next hydro date is either 3 or 5 years depending on the date. prior to 1/1/91 cylinder must be done every three years and after 1/1/91 they must be done every 5 years. I am stuck on the formula asd I have it now =IF($D$3<B16,1095+D3,1825+D3) any assitance would be of great help. Thnaks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
| Excel file modification date | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) | |||
Threaded Mode
