date and time macro or VB?

[Epicfail]

Ok hi guys / gals,

I have a time macro using =now() and i have the cells formated to show either the date or time. But the issue I have is I only want the date or the time entered instead of both. I need it to only have the date in the cell because im using it as a reference point and it doesnt work with the time in the cell also.

Currently-
Cell shows 3/30/09
Entered in cell 3/30/09 12:00:00 pm

Needing-
Cell shows 3/30/09
Entered in cell 3/30/09

Any ideas?

 

[Stormseed]

=today() ? or you can custom format the cell with only date ?

 

[Epicfail]

i have it formated to mm/dd/yyyy it shows correctly in the cell

But in the formula bar it shows mm/dd/yyyy hh:mm:ss am/pm

 

[balajayan]

Inside the macro to get current date use the "Date" as a variable. For example to assaign current date to variable datefunc the following syntax has to be used.

datefunc = Date

Hope this resolves your issue

 

[Epicfail]

Thnx guys

Another question i hv is can i make one marco do just the date(mm/dd/yyyy) in say cell A1 and then hv it do Time(12:00 pm) in cell A2?

 

[balajayan]

Hi Epicfail,

For the given scenario use the following syntax

Range("A1").Value = Date
Range("A2").Value = Time

Hope this works for you.