Hi all!
Having imported date information from a database, it appears as dd.mm.yyyy e.g. 10.04.2005 in my excel file.
I need to calculate and display the date a week in advance of this so i can schedule a production date....
This is what i need....
ColA 29.04.2005 ColB 20/04/2005
im really struggling...
have checked out other forums and have tried adapting other code an im pretty useless!
Having imported date information from a database, it appears as dd.mm.yyyy e.g. 10.04.2005 in my excel file.
I need to calculate and display the date a week in advance of this so i can schedule a production date....
This is what i need....
ColA 29.04.2005 ColB 20/04/2005
im really struggling...
have checked out other forums and have tried adapting other code an im pretty useless!