hello,
please can you help?
i have a spreadsheet for entering parts ordered
simple list of parts, but would like a column to show the date ordered without entering it
i.e. when i open sheet and enter a line i would like the date to automatically appear in say column F (to save time)
but
it needs to save it as that date so next time i go into the sheet it still shows that day and not the new day until i enter a new line on that day
i was thinking along the lines of =now() but this only keeps the day that the shet is opened
hopefully i made this clear
any help would be appreciated
kind regards
please can you help?
i have a spreadsheet for entering parts ordered
simple list of parts, but would like a column to show the date ordered without entering it
i.e. when i open sheet and enter a line i would like the date to automatically appear in say column F (to save time)
but
it needs to save it as that date so next time i go into the sheet it still shows that day and not the new day until i enter a new line on that day
i was thinking along the lines of =now() but this only keeps the day that the shet is opened
hopefully i made this clear
any help would be appreciated
kind regards