Hi everyone,
Just a quick pre-warning, I am very new to using Excel and and still learning everyday as I have only used excel to make tables.
I have been asked to make a document for receiving receipt's and have created this by watching you tube videos, I have got so far but now I am stuck.
I need to enter a Receipt number into column B then I need column A to automatically enter today's date then column C to automatically enter the expected date of completion (+ 5 days of date entered in column A) then column D to automatically enter Time left in days and finally column E to automatically enter the status of open. I think that I am half way there but I keep getting #VALUE error messages. I will attach a copy of my spreadsheet for you to have a look at what I have done, Any help will be very much appreciated.
Bookmarks