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 dearMr. Martin,
In my sheet A1 contains the Heading Date, & the first data is in Cell A2.
I have created another column B, in which I am entering this formula.
But, I have not been able to add or integrate any SMS service in this
file, nor enter my own phone number.
The AD In Excel To SMS, found
In my sheet A1 contains the Heading Date, & the first data is in Cell A2.
I have created another column B, in which I am entering this formula.
But, I have not been able to add or integrate any SMS service in this
file, nor enter my own phone number.
The AD In Excel To SMS, found