Is there a way to obtain the value of the month from a cell in Microsoft Excel? In VBA the function was MONTH (). I know that Applescript has a month function as well, but it doesn’t seem to return the proper value for me.
Here is a simple script that returns “missing value” when I use the date 1/1/2008 in the cell.
tell application "Microsoft Excel"
activate
set ThisMonth to month of cell 4 of row 42 as text
set formula of cell 5 of row 42 to ThisMonth
end tell