Could someone please tell me if there is a formula to do the following.
I have a formula which puts todays day in DayTextBox.
I have a formula which puts todays Date in DayTextBox.
What i want to do is then put in WeekEndDayTextBox an
WeekEndDateTextBox with the obvious data.
The weekending day will be a friday. I want to do this on a Monday so
need to check if today is Monday if it is then i want to set (o
Worksheet "DUMP") cell A1 as Monday-2 (ie Saturday),
cell a2 as Monday-1 (ie Sunday) etc until A7 as Monday+5 (ie Friday).
All controls are on a userform (VBA).
Is this possible?
As mentioned i only want to allocate the data to the worksheet on
Monday.
TI
--
Message posted from
http://www.ExcelForum.com