#1
|
|||
|
|||
using date function
i'm running office 2016 on my MacBook.
I realize excel is different than word. But in word I was able to create a Template whereby the date that I started the document that days date with pop up in that particular cell. Also another cell would be for edit a date which would change automatically each time document was open. is something like this possible using excel document question? hope some has some easy ideas. thnx |
#2
|
|||
|
|||
I'm not sure does this work in MacBook or not, and it is not fully foolproof solution, but when you have access to MS Excel, then you can check this out.
|
#3
|
|||
|
|||
I downloaded the file and have no idea whatsoever as to what im supposed to learn or do with this. sorry not very helpful.
|
#4
|
|||
|
|||
Quote:
sorry no help at all. |
#5
|
|||
|
|||
On 1st sheet, when date field doesn't contain any number (i.e. date, as date is a number in Excel), then user can enter/select only current date into date field. When date field contains a number which is >0, then only allowed entry will be red-colored warning text - and user can press Esc to cancel the entry, or select the warning text and after that overwrite it with current date.
2nd sheet is helper sheet, where validation list value (current date or warning text) is calculated. This sheet is meant to be at least Hidden, but Very Hidden (the sheet is not shown when user tries unhide sheets) is best option. |
#6
|
|||
|
|||
aha explanations....still bit difficult for me to understand.
still confused...I have not used excel in quite some time. and this task may not even be an option. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date Function | breen77 | Word | 18 | 07-11-2016 12:41 PM |
Excel date or edate function help | JohanB26 | Excel | 2 | 07-17-2013 09:23 AM |
If Function Challenge involving date | no1texan | Excel | 6 | 07-15-2012 12:58 PM |
Today's Date Function | freschij | Excel | 3 | 02-11-2011 10:21 AM |
Date Function in word? | aligahk06 | Word | 1 | 04-21-2010 06:33 AM |