Dates

[snapper1969]

Hi,

I process an excel file either on a friday, monday or tuesday. Is there anyway to send the nearest staurdays date to the spreadsheet?.

Thx,

John

[Marcus Tettmar]

Code to get nearest Saturday's date:

Code: Select all

GetDate>thedate
DayOfWeek>dow
If>dow<4
  //If today is Tuesday or less, get Sat gone
  Sub>thedate,dow
else
  //if today is Wed or more, get Sat coming
  Let>dow=7-dow
  Add>thedate,dow
endif