Calculation in Excel Custom Formats

[gauravkrgautam]

Hi All,

I am trying to update cell format i.e.

Gaurav kr gautam has created this file on 1-Jan-2014 to 6-Jan-2014

with only entering the dates.
I am done with first part but want second part

Regards,
Tarun Verma

 

[Asheesh]

It is not very clear what you looking for...?? can you please explain..

 

[Khalid NGO]

Hi Tarun,

I think you can use these 2 solutions:
1) Custom format as:
"Gaurav Kumar Gautam Created Sample Workbook On "d-mmm-yy" to 6-Jan-15"

2) Use Text formula as:
="Gaurav kumar gautam created sample workbook for week "&TEXT(D12,"d-mmm-yy" )&" to "&TEXT(D13,"d-mmm-yy" )

Where D12 & D13 having dates

See the example.

Regards,

 

[gauravkrgautam]

Thanks guys for looking in it.

@Khalid i want to get rid of cell reference and text function as you see in cell E7 input is only date and for viewer it is different than date.
i.e E7 = 1/1/2015
for viewer it is Gaurav kr gautam has created this file on 1-Jan-2014

so is it possible to calculate date+6 for viewer
i.e E7 = 1/1/2015
for viewer it should be Gaurav kr gautam has created this file on 1-Jan-2014 to 7-Jan-2014
@Asheesh hope it is clear now.

 

[Khalid NGO]

Hi Tarun,

I had given you the same example you were asking on 1st post, did you checked custom format in E11? (you need to update 2nd date every time)


I am not clear with your 2nd post:
"i.e E7 = 1/1/2015
for viewer it is Gaurav kr gautam has created this file on 1-Jan-2014 "

I think 1/1/2015 can not be formatted as 1-Jan-2014 in custom format, except you use some date formulas...

Also you can not +/- in Custom Formates.