I need to compare dates between columns F and I of a spreadsheet and return the number of days in excess of 50 into column K.
Parameters:
1. Calculation only needs to happen if a date is entered into column F
2. Dates will only be entered into column F if a position is vacant.
3. Dates will only be entered into column I when a vacant position is filled.
4. Column K will be used to contain the total # of days beyond 50. (if 56 days are between vacant and filed, the result will be 6, if less than 50, no calculation is necessary)
5. If no date is entered into column I (position filled), the calculation should be based on today's date. (only if more than 50 days)
6. calculation needs to apply to 200+ rows.
I have looked at datedif function but I cannot simply fill in the cells with the calculation because all worksheet data will be replaced monthly (text and formatting). I've added an activex button that will remain on the sheet and want a VBA code to run with the push of the button.
I've also looked at several vba codes that deal with single line date comparisons but nothing that addresses my concerns.
Any assistance is greatly appreciated.
Parameters:
1. Calculation only needs to happen if a date is entered into column F
2. Dates will only be entered into column F if a position is vacant.
3. Dates will only be entered into column I when a vacant position is filled.
4. Column K will be used to contain the total # of days beyond 50. (if 56 days are between vacant and filed, the result will be 6, if less than 50, no calculation is necessary)
5. If no date is entered into column I (position filled), the calculation should be based on today's date. (only if more than 50 days)
6. calculation needs to apply to 200+ rows.
I have looked at datedif function but I cannot simply fill in the cells with the calculation because all worksheet data will be replaced monthly (text and formatting). I've added an activex button that will remain on the sheet and want a VBA code to run with the push of the button.
I've also looked at several vba codes that deal with single line date comparisons but nothing that addresses my concerns.
Any assistance is greatly appreciated.