A Date with Excel? 1

[Tarquine]

Hi

I am attempting to create a form in Excel. This form is required to search for a date which is less than or equal to the current date. How can this be done? I have tried many things but to no avail can anyone help?

Regards

Tarquine



I don't care what others say. It's only breathing that gets you through life

 

[TonyU]

Could you explain how the form is supposed to work? I need more info... Tony

 

[Tarquine]

Hi Tony

Thanks for the quick response

The form I am attempting to design in excel 97 is for tracking equipment which has to be serviced at certain points through the year. What I would like to do is create a form which allows me to use the current date ie today's and look back throughout the year to see how many times this has happened. I would then add a price and this would show how much it has cost me.

I have tried to use the formula <=Date() however this did not work as requested. I can't get the &quot;<=&quot; aspect to work as it does in Access.

Hopefully this makes some sense.

Regards

Tarquine



I don't care what others say. It's only breathing that gets you through life

 

[Dreamboat]

Try <=NOW()

Date is usually access. Now is Excel.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[Tarquine]

Thanks DreamBoat for that bit of information. I have &quot;NOW&quot; managed to complete my little project. I did however have a problem with the sorting of the data when using <=NOW this turned out be be the date format, it was set for the US style eg mm/dd/yy.

Thanks once more for your help.

Regards

Tarquine



I don't care what others say. It's only breathing that gets you through life