Is there a way to Lock down a date formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using some Now() functions to show the date on current month reports,
but when those reports are opened in succeeding months the dates then change
to the new current month. Is there a way to keep the data automated but at
month end lock the field? As opposed to copying and saving the date as a
value.

Thanks for any help on this.
Tiffany
 
Hi Tiffany,

you could use

=if(today()>date(2006,08,31),date(2006,08,31),today())

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Tiffany C." escreveu:
 
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

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Excel Message box with days of month & date. 1
Excel Vba to change displayed year automatically. 14
Counting dates with specific criteria 1
Copying a cell if dates match 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Formula to figure out months between two dates 3
Excel Help with dates 2

Back
Top