Andrew has attended:
Excel Advanced course
Dates
In Excel can you program a formulae to take a date (Invoice Date) and add 30 days etc.
RE: Dates
Hi Andrew,
Have you tried to take a date say in A1 and in your destination formula put =A1 +30? ensuring you format the cells to read the number or do you want something more complicated? I would doubt whether you could set this type of construction inbuilt...
regards
Tracy