excel help - text formula with date

[Mallesh23]

Hi Team,

I am looking for text formula with Date, want to convert date as per my requirement.

Book3
	C	D	E	F	G
3	Print Today Date	Todays date	Previous day	Previous Month	Previous Quarters
4
5	Expected	09-Jun	08-Jun	08-May
Sheet1

Thanks
Mallesh Gangadhar
Mob - 8208459313

 

[Joe4]

In D5: =TODAY()
in E5: =TODAY()-1
in F5: =EDATE(TODAY(),-1)
(if using a European version, it may need to be):
=EDATE(TODAY();-1)

And then just apply the Custom format to those cells of dd-mmm

 

[Mallesh23]

Hi Joe,

thanks it worked !

How to use text with date and format the date, as I was getting error.

Below not working
=TEXT(date(),"dd-MMM")




Thanks
mg

 

[Joe4]

date() is not valid. If you use the DATE function in Excel, it requires three arguments and you need to provide the month, day, and year values.
You use TODAY() to get the current date, i.e.

=TEXT(TODAY(),"dd-MMM")