Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2020, 06:19 PM
lori2020 lori2020 is offline using date function Mac OS X using date function Office 2016
Novice
using date function
 
Join Date: Feb 2020
Posts: 6
lori2020 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-25-2020, 06:19 AM
ArviLaanemets ArviLaanemets is offline using date function Windows 8 using date function Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

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.
Attached Files
File Type: xlsx RegisteringDate.xlsx (10.9 KB, 3 views)
Reply With Quote
  #3  
Old 02-25-2020, 09:12 AM
lori2020 lori2020 is offline using date function Mac OS X using date function Office 2016
Novice
using date function
 
Join Date: Feb 2020
Posts: 6
lori2020 is on a distinguished road
Default

I downloaded the file and have no idea whatsoever as to what im supposed to learn or do with this. sorry not very helpful.
Reply With Quote
  #4  
Old 02-25-2020, 09:14 AM
lori2020 lori2020 is offline using date function Mac OS X using date function Office 2016
Novice
using date function
 
Join Date: Feb 2020
Posts: 6
lori2020 is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
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.
I downloaded the xlsx file and have no idea what so ever as to what I am supposed to learn from it.

sorry no help at all.
Reply With Quote
  #5  
Old 02-25-2020, 11:32 AM
ArviLaanemets ArviLaanemets is offline using date function Windows 8 using date function Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

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.
Reply With Quote
  #6  
Old 02-25-2020, 12:47 PM
lori2020 lori2020 is offline using date function Mac OS X using date function Office 2016
Novice
using date function
 
Join Date: Feb 2020
Posts: 6
lori2020 is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
using date function 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
using date function 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


All times are GMT -7. The time now is 04:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft