help with formula

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

If C3 has a "0" then I would like for the current date mm/dd/yy in E3 without
having to type it in each time. I've tried the Now() function but it changes
each day. I'd like for it to remain the same date without changing each day.
 
You can't do that without using code.
Ctrl and ; (semicolon) will enter a static date.
Regards,
Alan.
 
=IF(B3="","",IF(C3="",NOW(),C3)) tools/calculations/iteration. I use this
formula and it works fine for what I need and the date does not change but I
can't figure out how to reword the other formula
Thanks in advance!
 
NOW() and TODAY() will recalculate every time the sheet recalculates. There
is no function that will insert a static date using a formula.
You can Paste Special > Values the formula, but that would defeat the
object, use Ctrl ; or use VB code, but it can't be done with a formula.
If you wan't to go down that road, post back.
Regards,
Alan.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Find closest future date from list ... 3
date formula issues?!?! 1
How do I delete merged cells in Excel without deleting the final d 5
Returning the month (mmm) from cell in date format dd/mm/yyyy 1
change DD/MM/YY to MM/DD/YY 6
Can't graph data with Date Format with hours 2
Excel 2002: How to make the date format uniform ? 1

Back
Top