K
Kayden
I have cells with dates in them and I need to create a
function that will allow me to type in a number (-30 for
days prior) and tell me what the date was X amount of days
prior to the date in that cell. So far I have "=(date
(year,month,day)-30" which will give me the correct
answer, however I need to have something along the lines
of "(date(B12)-30)" and get the same result. Any ideas?
function that will allow me to type in a number (-30 for
days prior) and tell me what the date was X amount of days
prior to the date in that cell. So far I have "=(date
(year,month,day)-30" which will give me the correct
answer, however I need to have something along the lines
of "(date(B12)-30)" and get the same result. Any ideas?