In Cell (C5:Z13) type: NN (Think 1 day), N (Think again day), Y (Dates of
Rest) to see results
2014-08-03 14:17 GMT+07:00 Rajeev :
> Dear Experts,
>
>
>
> I need help that in my worksheet Where I entered dates (Sheet1) in column
> A, in column B I have entered “Y” as working days and “N” as no
Dear balbir,
You can use EOMONTH function..
=EOMONTH(DATE,No. of Month)
Thanks,
Noorain
On Wed, Aug 11, 2010 at 4:44 PM, balbirkumar . wrote:
>
> Dear Friends,
>
> I want to add months to data which is in date format.
> please suggest me the way out.
> I have got data in date format as 25/
Hi,
If you have the Analysis Tool Pack loaded, use EDATE. It's very
straight-forward.
If your date is in A1, then in another cell: =EDATE(A1,50). Format using a Date
fromat.
If you don't have it loaded, it comes with XL. Tools menu, Add-ins, tick
Analysis Toolpack.
Regards - Dave.
Date:
