marreco
03-09-2012, 07:11 AM
I have a spreadsheet that compares the data from tab "Operações" and generates a flow on the tab "Fluxo", this three capstan in a code module "Create_flow."
But this code parses the data in column "F", and estimates against time.
but when I have a date that falls on Friday, in the "I" the result is like Sunday, but can not should be on Monday.
See line 2 of the tab "Fluxo."
He was made a purchase on 28/02/2008 after 31 days (column "F"), should fall on 31/03/2008 (column "I").
The dates in Brazil is (dd / mm / yyyy) and not (mm / dd / yyyy).
So what I want is if the dates in column "I" tab "Fluxo" falls on a Sunday or s'bado to be changed to Monday.
Thank you.
But this code parses the data in column "F", and estimates against time.
but when I have a date that falls on Friday, in the "I" the result is like Sunday, but can not should be on Monday.
See line 2 of the tab "Fluxo."
He was made a purchase on 28/02/2008 after 31 days (column "F"), should fall on 31/03/2008 (column "I").
The dates in Brazil is (dd / mm / yyyy) and not (mm / dd / yyyy).
So what I want is if the dates in column "I" tab "Fluxo" falls on a Sunday or s'bado to be changed to Monday.
Thank you.