Forum Discussion
Getting SMS from my Excel file for specific dates to my own phone
I have used the following formula in my Excelsheet, in an extra column "B" as under:- =IF(A2=TODAY(),,"C2&D2&E2&F2""") But, it is giving an error message. How do I get over this issue?
Hi ColSaxena
if you want to concatenate the cells, the formula should look like this:
=IF(A1=TODAY();C2&D2&E2&F2)
In case A1 is not todays date, it will just return FALSE
Kind regards,
Martin
Thanks dear Mr. Weiss,
In my sheet, A1 is the heading marked Date, & A2 is the first data.
That is why I wrote A2=.
I have not been able to get any method of providing my own phone
in this file.
An Ad In called Excel To SMS, found by google Search, was downloaded.
But it is not getting activated on my system.
could you please help further.
regards,
Col Saxena