Hello,
Definitely yes. You can get date-1 by using =today()-1 function in excel, copy using CTRL+c and assign it to some variable and use it in your task.
What you can do is as follows:
Go to cell A1 in excel file, and write =today()-1 and hit Enter.
Now hit UP Arrow key and CTRL+C to copy the value.
Assign $Clipboard$ value to some variable.
Now use this variable in your task.
Hope that helps. |