Using date to populate cell

**MarkoGreenio** · 09-20-2023, 05:44 AM

Good morning all, Is there a formula or function I can use (perhaps a =IF?) where I can make a certain formula's value appear in a cell only after a certain date and time? I did find something on the forum that partially helped, however the date was hard coded into the formula and I would prefer it to look it to the other cell(I am 99% there).
If you notice on my sample sheet, nothing is populated in B7 because the date is tomorrow.
Any help would be appreciated as always so thank you in advance.

Mark

**AliGW** · 09-20-2023, 05:46 AM

Are you still using Excel 2016?

**AliGW** · 09-20-2023, 05:51 AM

Not clear, but is this what you want?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	E
1	Date	Apples	Apples
2	01/09/2023	4	4	05/09/2023
3	02/09/2023	4	4
4	03/09/2023	4	4
5	04/09/2023	4	4
6	05/09/2023		4
7	06/09/2023		4

Sheet: Sheet1

In B2 copied down:

=IF(A2<E$2,C$2,"")

**MarkoGreenio** · 09-20-2023, 06:01 AM

Thanks AliGW for the reminder. Changed it now to 365

**AliGW** · 09-20-2023, 06:02 AM

And does my suggestion help? I wasn't clear on your intentions.

**MarkoGreenio** · 09-20-2023, 06:06 AM

Thank you for the reply and sorry for not being clear, essentially what I wanted was the date part in the formula in B2 =IF(NOW()>DATEVALUE("01/09/2023")+TIME(16, 0, 0), C2, "")
to reference the date in A2, at the moment the date is hard coded into the formula.
Hope that makes sense.

**AliGW** · 09-20-2023, 06:15 AM

Do you mean this?

=IF(NOW()>A$2+TIME(16, 0, 0), C$2, "")

Seems an odd thing to be doing - if you explained your reasoning, you'd probably get better advice!

**MarkoGreenio** · 09-20-2023, 06:20 AM

Thank you but it is hard to explain sometimes but thank you for the help and your not very nice comment at the end!

**AliGW** · 09-20-2023, 06:25 AM

What was not very nice about it? I was suggesting that you explain the context because there may be a better way to do what you are doing! I was being pragmatic. What a strange reaction to someone offering to coach you!!!

**MarkoGreenio** · 09-20-2023, 06:29 AM

Fair enough, apologies for being prickly. I appreciate the help and reputation added

**AliGW** · 09-20-2023, 06:33 AM

I'll let you off - this time. It was completely uncalled for, though, and it might have made me less inclined to offer you help and advice in the future.

What you are doing in that formula does not look efficient, but if you won't share the wider picture, then I can't guide you and give you the benefit of my own experience.

Using date to populate cell

LinkBack

Thread Tools

Rate This Thread

Display

Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Re: Using date to populate cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Populate Cell with specific Date

[SOLVED] Populate cell with the day's date based on inputting anything into adjacent cell

[SOLVED] Populate cell based on date, if not date then blank

Populate cell with current date and time, then lock cell

[SOLVED] Populate Cell with Q1, Q2, Q3 or Q4 depending on date

Populate date based on a date in another cell

How to populate a value in the cell based on date?

Bookmarks

Bookmarks

Posting Permissions