Thread: get back to day one based on current date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oomyoo
 
Posts: n/a
Default get back to day one based on current date
Hi,

I would like to have the following:

A1 B1
=TODAY() need formula

Cell should say:
A1 B1
12/20/05 12/1/05

Any ideas?

Thanks in advance :)


Reply With QuoteReply With Quote