Alright I'm trying to figure this out, but I fear I'll have to venture into VBA.
I have an options pricer, which works just fine, but I'm trying to improve it a bit more.
I have in one cell today's date: = Today()
Another cell or column I should say which spits out the delivery month based off that one cell... =Date(year($A$1), Month($A$1), Day(1))
And finally, I have an additional column that gives me the expiration date based on the delivery month column....
=Workday(EOMONTH($B4,0)+1,-4,Holidays!$D4)
I would like that last column to have the expiration date AND time (2:30 PM).... how would I go about doing this?
Thanks for any help.
I have an options pricer, which works just fine, but I'm trying to improve it a bit more.
I have in one cell today's date: = Today()
Another cell or column I should say which spits out the delivery month based off that one cell... =Date(year($A$1), Month($A$1), Day(1))
And finally, I have an additional column that gives me the expiration date based on the delivery month column....
=Workday(EOMONTH($B4,0)+1,-4,Holidays!$D4)
I would like that last column to have the expiration date AND time (2:30 PM).... how would I go about doing this?
Thanks for any help.
